**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

please share

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

is it 24/7 ?

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

But experts are always online for us to help you. :)

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.*