View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crowdx42[_18_] crowdx42[_18_] is offline
external usenet poster
 
Posts: 1
Default Inserting and deleting spaces with a macro


Ok,
so I have names in a column which I want to both insert a space afte
a "," and then delete everything after the second word space. i.e
James,Patrick Coogan needs to be
James, Patrick
Can this be done?
Thanks in advance
You guys have been very patient and I very much appreciate all th
help.
Patrick:

--
crowdx4
-----------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57405