Help with a formula

[newfhugger]

I have a cell that contains client name in the format LAST, FIRST and
need to exctract the two words and place them in separate cells. An
thoughts on a formula to accomplish this?

Thank

 

[Frank Kabel]

Hi
one way: use 'Data - Text to columns' for this

 

[Biff]

Hi!

Use the Text to Columns command for this.

If your data is in col A and one of the names is like
this: Smith, Bob, using the T to C feature will leave
Smith in col A and put Bob in col B.

Select the range of names.
Goto Data>Text to Columns
Click: Next
Check: Comma
Click: Finish

Biff

 

[newfhugger]

That did the trick!

Thanks for your help

 

[John Mansfield]

Hi,

Assuming your name is in cell A1, to extract the last name
place the following formula in one cell:

=LEFT(TRIM(A1),(FIND(",",TRIM(A1))-1))

To extract the first name, place the following formula in
another cell:

=MID(TRIM(A1),FIND(" ",TRIM(A1),1)+1,LEN(TRIM(A1)))

John Mansfield
pdbook.com