Combination of text in 2 columns

  • Thread starter Thread starter eintpc5146
  • Start date Start date
E

eintpc5146

Have a list of names--
first cell contains FirstName, MI; second cell contains LastName;
Need to combine data into 3rd cell;
output of 3rd cell:
(e-mail address removed)

What is the easiest way to do this??
Thanks for your help!
 
Maybe this with your names in A1 and b1

=A1&"."&B1&"@xxx.com"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Thanks Mike, it helped. I am, however, picking up the middle initial and I
don't need it. How do I keep it out?
Thanks!
ei
 
Try inserting a column between a & b. Select B1 and click insert, column.
Then Highlight the names in column A. Select Data, text to columns. Choose a
comma as the delimiter, and click finish. Column A should now contain just
the first name, and column B the middle initial. You can delete column B if
you don't need it, and then Mike's formula will give you what you want.

Jim
 
eintpc5146;951517 said:
Have a list of names--
first cell contains FirstName, MI; second cell contains LastName;
Need to combine data into 3rd cell;
output of 3rd cell:
(e-mail address removed)

What is the easiest way to do this??
Thanks for your help!
Click to expand...

You can use this formula directly to get the required name
=CONCATENATE(LEFT(A1,SEARCH(",",A1,1)-1)," "&B1)

Ex: A1 has Bert, P and B1 has Nelson, the above pulls "Bert Nelson" to
C1

all the best
 
Back
Top