View Single Post
  #1   Report Post  
 
Posts: n/a
Default Function to remove a space from text in cell WITHOUT macro??

Hi All,
I have a worksheet which takes values from other worksheets and I use this
to export to .csv so that I can script adding users to Novell using JRB
utils.

The problem I have is that some of our objects have spaces in the name and
the utility I use doesn't like that. I'm looking for some info on making
this change in the CELL and NOT writing a macro to do it so that others may
user this spreadsheet without knowledge of how to run or edit macro's should
anything change.

Any help appreciated

J