Full Version: Suggestion for another macro.
From: Carl (CSEWELL) [#5]
6 Sep 2006
To: logojohn [#4] 8 Sep 2006
quote:
I assume there is no magic trick to convert a Lastname, First name listed in one column into Firstname Lastname
Why, there just happens to be!!!
Place the "Lastname, Firstname" in A1. Then place the first line below in B1 and the next line in C1, and see what develops:
=LEFT(A1,FINDB(",",A1,1)-1)
=RIGHT(A1,LEN(A1)-FINDB(",",A1,1)-1)
And then copy the functions to the cells underneath.
WARNING! Hasn't been fully debugged, but what do you expect for a few seconds of work?
From: Shaddy [#6]
6 Sep 2006
To: logojohn [#4] 8 Sep 2006
Although I would use code similar to Carls, there's also a wizard in Excel to do it, called "Text to Columns" (under the Data menu). Follow the directions, in this case using a comma as the delimiter.
Shaddy