View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Remove _ inside of string

If you have lots to do,

select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all

You can record a macro to see the code.

ranswert wrote:

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


--

Dave Peterson