Help with manipulating text in Excel 2003
 

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!

Help with manipulating text in Excel 2003
 

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.

"Big UT Fan" wrote:

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!

Help with manipulating text in Excel 2003
 

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)


--
Gary''s Student - gsnu200778


"akphidelt" wrote:

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.

"Big UT Fan" wrote:

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!

Help with manipulating text in Excel 2003
 

On Wed, 9 Apr 2008 10:38:01 -0700, Big UT Fan
wrote:

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

This should help.

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