Thread: Macro to find string and remove, but leave the rest of cell conten
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_852_] Simon Lloyd[_852_] is offline
external usenet poster
  
Posts: 1
Default Macro to find string and remove, but leave the rest of cell conten

Try this link, the values that you see in the macro i.e 52,39 etc are
the amount of characters you wish to remove (including spaces) have a
play around with it!

http://www.excelforum.com/showthread.php?t=566863

Regards,
SImon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=569537

Reply With QuoteReply With Quote