For the name:

C3 = lastname,firstname

First name:

=MID(C3,FIND(",",C3)+1,255)

Last name:

=LEFT(C3,FIND(",",C3)-1)

For the address:

F3 = city, state zip
( in that format. one comma after city and a space after state)

You also have a space after the comma.

For the state:

=TRIM(SUBSTITUTE(MID(F3,FIND(",",F3)+1,255),H3,"") )

I'm using the TRIM function just in case there may or may not be a space
after the comma.

For the zip code:

=RIGHT(F3,5)

I'm assuming there are no zip+4's

Biff

"Eelinla" wrote in message
...
Hi, I am a bit stuck with my excel spreadsheet. Any help anyone could give
me
would be appreciated.
Im working on moving text information (lastname,firstname) format to
separate categories while maintaining the original column. It will be
used
in statistical functions after it is moved and must be formulated so that
if
the information is changed (ie marriage changes a last name) it will
remain
accurate and consistant.

following is an example:

column C contains the lastname,firstname in that format. no space just the
comma.
I need to move the first name to column D
I need to move the last name to column E

I also need to format the city, state zip in the same manner

Example:
column F contains city, state zip ( in that format. one comma after city
and
a space after state)
I need to move the the state to column G
I need to move the zip to column H ( I assume using the =Right F3,5
command
should work for this one.)