Thread: EXCEL FORMULAS
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 153
Default EXCEL FORMULAS

If the data is consistant, then Menu-Data/Text to
columns/Delimted(Character, such as
commas....)/Next/Space/Next/Finish


-----Original Message-----
This might be an incredibly easy solution to my problem,
but I cannot think of it !!
I have a list of employees which is set out in the

format
of first name, then surname e.g. John Smith.
I want to turn that around to read Smith John - is there

a
way of doing this ??

Thanks !!
.