# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to formula to suffix prefix ' (single inverted comma) like 'MITHILA', and comma at the end MITHILA will be in column A and I want result in column B
Solved by T. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/04/2018 - 02:25
hell there! :)
User 07/04/2018 - 02:25
yes
User 07/04/2018 - 02:25
I am here
Excelchat Expert 07/04/2018 - 02:25
*hello :)
User 07/04/2018 - 02:26
perfect
User 07/04/2018 - 02:26
you got it right
Excelchat Expert 07/04/2018 - 02:26
I've made a sample set of records in document preview :)
Excelchat Expert 07/04/2018 - 02:26
Nice! :)
User 07/04/2018 - 02:26
this is super cool
User 07/04/2018 - 02:26
what formula you used
User 07/04/2018 - 02:27
Excelchat Expert 07/04/2018 - 02:27
I used the CONCATENATE function. You can view the formula if you select the cells in column B
Excelchat Expert 07/04/2018 - 02:27
=concatenate("'",A1,"',")
Excelchat Expert 07/04/2018 - 02:27
basically, with CONCATENATE, you can combine sets of texts :)
Excelchat Expert 07/04/2018 - 02:27
first text is the '
Excelchat Expert 07/04/2018 - 02:28
the next set of data is the word you wish to enclose with '
Excelchat Expert 07/04/2018 - 02:28
and the next set of text is ',
User 07/04/2018 - 02:28
yes got it
Excelchat Expert 07/04/2018 - 02:28
Nice! I'm glad I was of help. :)
User 07/04/2018 - 02:28
can I use this chat facility any time
User 07/04/2018 - 02:28
User 07/04/2018 - 02:28
all days of the week
User 07/04/2018 - 02:29
is it free
Excelchat Expert 07/04/2018 - 02:29
yep you can always ask questions 24/7! as per our policy, we can only answer one question per session :)
Excelchat Expert 07/04/2018 - 02:29
I think it's free on the first question.
Excelchat Expert 07/04/2018 - 02:29
But next questions will have a price on it. :)
User 07/04/2018 - 02:29
only for the first one .
Excelchat Expert 07/04/2018 - 02:29
User 07/04/2018 - 02:29
where can I find the pricing
User 07/04/2018 - 02:30
ok,thanks
Excelchat Expert 07/04/2018 - 02:30
Sure thing! Glad to be of help. :)
Excelchat Expert 07/04/2018 - 02:30
You can find more data in here: https://www.excelchat.co/pages/help.html
Excelchat Expert 07/04/2018 - 02:32
you can manually end the session by the way on your side (I can't do it from my side). BTW, a 5-star rating and feedback would be superb. Have a nice day and thanks once again! :)
User 07/04/2018 - 02:33
yes sure
Excelchat Expert 07/04/2018 - 02:33
Thanks and see you! :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.