Thread: Extracting text from a string
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Extracting text from a string
Hi,
You could use Edit Replace, but you'd have to use it twice.
1st time: Replace R/ with nothing. Replace all.
2nd time: Replace / with a space. Replace all.
Regards - Dave
Reply With QuoteReply With Quote