barrett@thebrooksgroup.co
New Member
- Joined
- Apr 21, 2002
- Messages
- 3
I import lists into Excel. Before formatting phone or fax numbers, I remove these characters ()- and "spaces" in the numbers. However, I sometimes find a "space" after the number. When I run a Find/Replace, where I find the "space" and then replace it with nothing, the "space" still remains and I cannot format it. Are you aware of this situation and what can I do to remove the "space" AFTER the numbers? BTW, this also occurs with Zip Codes as well.