I need a string that will be a name and email address. Please see sample file. The text string ends with a >, (bracket, comma, space). Thanks.
I need a string that will be a name and email address. Please see sample file. The text string ends with a >, (bracket, comma, space). Thanks.
Try this:
=""""&A3&""""&" <"&C3&">,"
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
another option:
=CHAR(34)&A3&CHAR(34)&CHAR(32)&CHAR(60)&C3&CHAR(62)&CHAR(44)
or with CONCATENATE function:
=CONCATENATE(CHAR(34),A3,CHAR(34),CHAR(32),CHAR(60),C3,CHAR(62),CHAR(44))
Last edited by sandy666; 04-29-2017 at 01:41 AM. Reason: typo
This formula works. I just needed to know, What is the purpose of the four quote marks?
And how do you mark a question solved?
I've marked the thread as solved for you using the forum tools drop-down at the top of the thread. The four quotation marks are necessary for Excel to understand that you want to include quotation marks within the first text you wish to concatenate, because every piece of concatenated text needs quotation marks round it. Try the formula without them and you'll see why they are there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks