hey yer barred
Board Regular
- Joined
- Jun 19, 2007
- Messages
- 232
Hi All!
I have over 500 names in a list and i need them in a normal name format...they currently look like this -
jones, keith 41256
I want them like this for reporting reasons
Keith Jones
On every name, there will always be a 5 digit number at the end and always a ',' sperating the last name from the first name.
Is there some sort of function in excel that will do this for me, as I really dont want to type all 500 names! ...plus this will need changing as new people come and go all the time!
Many Thanks
Justin
I have over 500 names in a list and i need them in a normal name format...they currently look like this -
jones, keith 41256
I want them like this for reporting reasons
Keith Jones
On every name, there will always be a 5 digit number at the end and always a ',' sperating the last name from the first name.
Is there some sort of function in excel that will do this for me, as I really dont want to type all 500 names! ...plus this will need changing as new people come and go all the time!
Many Thanks
Justin