Re: Help with a formula

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

"newfhugger >" <<newfhugg...@excelforum-nospam.com> schrieb im
Newsbeitrag news:newfhugg...@excelforum-nospam.com...
> I have a cell that contains client name in the format LAST, FIRST and
I
> need to exctract the two words and place them in separate cells. Any
> thoughts on a formula to accomplish this?
>
> Thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

[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

>-----Original Message-----
>I have a cell that contains client name in the format
LAST, FIRST and I
>need to exctract the two words and place them in separate
cells. Any
>thoughts on a formula to accomplish this?
>
>Thanks
>
>
>---
>Message posted from http://www.ExcelForum.com/
>

>.
>

[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