Help with manipulating text in Excel 2003

[Big UT Fan]

I have a column which is in the format of "Lastname, Firstname
textidonotcareabout".
I'd like to change the text to Firstname Lastname via a function. Is this
possible? If not then I'm trying to learn some basic VBA programming so a
macro could be an option. Thanks in advance!

 

[akphidelt]

Try using Data-->Text-to-Columns... then go to Delimited and select space.

Other then that I know functions to switch last and first names but not with
extra data involved.

 

[Gary''s Student]

With data in A1, first find the first space, in B1 enter:

=FIND(" ",A1,1)

To find the second space, in C1 enter:

=FIND(" ",A1,B1+1)

Finally in D1:

= MID(A1,B1,C1-B1+1) & LEFT(A1,B1-2)

 

[Ron Rosenfeld]

I have a column which is in the format of "Lastname, Firstname
textidonotcareabout".
I'd like to change the text to Firstname Lastname via a function. Is this
possible? If not then I'm trying to learn some basic VBA programming so a
macro could be an option. Thanks in advance!

Perhaps:

=LEFT(TRIM(MID(A1,FIND(",",A1)+1,255)),FIND(" ",A1))
& TRIM(LEFT(A1,FIND(",",A1)-1))

--ron

 

[GoBow777]

I have a column which is in the format of "Lastname, Firstname
textidonotcareabout". I'd like to change the text to Firstname Lastname
via a function. Is this possible? If not then I'm trying to learn some
basic VBA programming so a macro could be an option. Thanks in advance!

This should help.

http://www.cpearson.com/excel/FirstLast.htm