In column E I have a list of 400 first names and in column F I have a list of their last names. How do I merge the first letter with the last name in another column. Column G is what I want in the below example.
ExcelProb.pdf
In column E I have a list of 400 first names and in column F I have a list of their last names. How do I merge the first letter with the last name in another column. Column G is what I want in the below example.
ExcelProb.pdf
There is nothing in column G in the example...
But I believe what you are looking for is this:
=CONCATENATE(LEFT(E1,1), F1)
That will make this
Jake Masters
Look like this:
JMasters
Yes that's what I want in column G. I have 400 names in both colums. How do I do the whole colum with all the names at once?
Amorous,
Type/copy the formula that Jake has given you in post # 2 above, to Cell G1 in your workbook, then copy the formula down Column G as far as required.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks