Combination of text in 2 columns
 

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:


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

Combination of text in 2 columns
 

Maybe this with your names in A1 and b1

"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"eintpc5146" wrote:

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:


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

Combination of text in 2 columns
 

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

"Mike H" wrote:

Maybe this with your names in A1 and b1

"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"eintpc5146" wrote:

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:


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

Combination of text in 2 columns
 

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" wrote in message
...
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

"Mike H" wrote:

Maybe this with your names in A1 and b1

"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"eintpc5146" wrote:

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:


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