Thread: Replace Comma with "-".
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Replace Comma with "-".
hi
see your other post.

Regards
FSt1

" wrote:

Hello,

I would like to replace commas with a hyphen/dash. For example cell
A1 contains "ABC,DEF,GHI", I would like to replace the "," with "-"
i.e. "ABC,DEF,GHI".

I attempted to use REPLACE(A1,FIND(CHAR(","),A1),1,",") but this only
replaces the first ",".

I need to find out how many "," are in the text and replace them all.
I know I could use find and replace but I need to use a formula.

Thanks in advance,

Brett

Reply With QuoteReply With Quote