I have done this before but i can not for the life of me find my formula
i have cells which read as follows
Bolster, Lorna
Murry, Peter
Hogg, Emma
I want to include two cells beside this which will read
Surname (needs to include the comma) and First name.
I didnt even do a workbook because in my heart i know this is simple!
Thanks
Lorna
Bookmarks