Deleting a space between a group of Numbers & Letters in a cel
It says that " " can not be located?
"Trevor Shuttleworth" wrote:
Melissa
why not just use a global Replace of " " for "" (nothing)
Regards
Trevor
"Melissa" wrote in message
...
I'm trying to delete a single space between a group od items:
ACE 12408 ------------I'm looking for ACE12408
I have over 10,000 lines so I'm looking for a shortcut.....Help ME
please!!!
Thanks
|