Thread: Pesky spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Pesky spaces

I have a column of names that are current formatted as "lastname space space
firstname". However, what I would like to see is the column formatted as
"lastname comma space firstname". Essentially, I would like to change the
first space into a comma. Any ideas on how? The names are all different
lengths. Please note I do not know any VBA.