Formatting excel account numbers

I am trying to format hundreds of account numbers with beginning and ending apostrophes and each number ending with a comma.

I have the comma added as follows:=B2&","
I have the beginning apostrophe as follows: ="'"&C2
However I am not able to get the ending apostrophe or the two above to work properly.

Data set currently has accounts as follows 100-100-100, I am looking to have all the data as '100-100-100',
I need the data in this format for SQL import.


Thank you

Mark
manelson05Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

manelson05Author Commented:
I think I got it

="'"&B2&"'"&","

Look correct?
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
this?

="'" & B2 & "', "

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
manelson05Author Commented:
Ryan

My expression seemed to do the same thing but I award to you since yours is cleaner and you taught me to keep the construct in the last declaration.

Thank you sir, I appreciate you!

Mark
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.