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
|