Thread: Replace "dash" with "space"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Replace "dash" with "space"
=SUBSTITUTE(B1," ","-",LEN(B1)-LEN(SUBSTITUTE(B1," ","")))

and copy down

--
__________________________________
HTH

Bob

"Turkey" wrote in message
...
What is the formula to replace "-" with space starting to count from the
right side. I need this to be done in a whole column


Reply With QuoteReply With Quote