Combination of text in 2 columns

[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!

 

[Mike H]

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.

 

[eintpc5146]

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

 

[Jim]

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

 

[bala_vb]

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!

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