<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Hi
I have a list of 200 client names in the format [Surname], {Firstname] as listed below, however some of the names are [Firstname] [Lastname]. These both names are grouped together in the 1 cell (Note:I have highlighted with * and they dont have a comma).
I require a formula to go through the list, identify the cell with No comma, and to swap text around such that it reads [Surname], [Firstname].
<o> </o>
Algie, Leanne
*Andrew Monsif
Eather, Ryan
Kulevski, Ken
*Damon Gillmore
Syeda, Sanjana
Baricz, Andrea
*Andrew Praulins
Nixon, Annette
*Janet Kazmierczak
Sciacca, Judi
*Kylie Van der Hoek
<o> </o>
Please also take note of the last name on the list, the end result when applying the foruma should read 'Van der Hoek, Kyile"
Hi
I have a list of 200 client names in the format [Surname], {Firstname] as listed below, however some of the names are [Firstname] [Lastname]. These both names are grouped together in the 1 cell (Note:I have highlighted with * and they dont have a comma).
I require a formula to go through the list, identify the cell with No comma, and to swap text around such that it reads [Surname], [Firstname].
<o> </o>
Algie, Leanne
*Andrew Monsif
Eather, Ryan
Kulevski, Ken
*Damon Gillmore
Syeda, Sanjana
Baricz, Andrea
*Andrew Praulins
Nixon, Annette
*Janet Kazmierczak
Sciacca, Judi
*Kylie Van der Hoek
<o> </o>
Please also take note of the last name on the list, the end result when applying the foruma should read 'Van der Hoek, Kyile"