Ask Mac Questions and Get Answers from Experts ASAP
Let's say that the names are XXXXX XXXXX A starting from cell A2, and the email server names are XXXXX XXXXX B starting from cell B2,
in cell C2 paste or type the following formula:
Then fill this formula down to the last row (Edit > Fill > Down)
Finally if you want to fix the results select column C, click Edit > Copy, then click Edit > Paste Special > Values. Now you can copy the list in column C to other applications.
Hope this helps. Let me know if you have any questions.
That was just an example because i do not know which columns your data is in.
If you can tell me which column has the Names and which column has the email servers I will modify the formula to work with these columns.
I see, so you want @gmail.com added to ALL the names.
In that case paste or type this formula in cell B2:
And then follow the rest of the instructions in my previous post.
Let me know.