Positioning text in a cell?

[bcox4e]

Hello all, I'm new to the Forum and wish I had been hanging out here a lot sooner. As I read various post I am finding out just how ignorant I am when it comes to Excel. Prior to joining the Forum I would have thought I could have at least taught an Excel 101 class at community college. Now, not so much...

Anyway, we have client data we need to create labels from but the data needs to be repositioned. Currently it reads "LastName, FirstName" in each column. How can I format that column to read "FirstName LastName"?

Thanks!

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	LastName, FirstName	FirstName LastName

[AliGW]

Welcome to the forum!

With your first name in A1, this in B1 drag copied down:

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

[bcox4e]

AliGW and AlKey, thank you both so much. Now I have to learn how and why that formula works. I really appreciate the promptness and expertise!

[AliGW]

AlKey's is cleverer than mine, and more efficient, but working out how each works will teach you different and useful skills. Shout if you need explanations.

Please mark the thread as solved.

[AliGW]

To mark as solved, select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.