Thread: Remove _ inside of string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Converse[_2_] Roger Converse[_2_] is offline
external usenet poster
  
Posts: 45
Default Remove _ inside of string
Hello,

This should work.

=SUBSTITUTE(A1," ","")


HTH,
Roger



"ranswert" wrote:

Is there a function that will remove the space inside a string? For example
change "string 1" to "string1".
Thanks
Reply With QuoteReply With Quote