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.
