- Joined
- Apr 23, 2008
- Messages
- 7
- Reaction score
- 0
Hi all this is my first post on Pc Review so I hope i've posted in the correct forum?
I am currently working on a spread sheet containing telephone numbers. I need to upload them on my telephone system, but in order to do so, all spaces in the telephone number cells must be omitted. So that I dont have to go through 500 + cells mannually to omit the space between the area code and telephone number, I'm hoping someone can advise me if there is an easier way of doing this??
I only have a basic knowledge of Excel so assistance in 'dummy' terms would be most appreciated!
Many thanks for reading
Moomin
I am currently working on a spread sheet containing telephone numbers. I need to upload them on my telephone system, but in order to do so, all spaces in the telephone number cells must be omitted. So that I dont have to go through 500 + cells mannually to omit the space between the area code and telephone number, I'm hoping someone can advise me if there is an easier way of doing this??
I only have a basic knowledge of Excel so assistance in 'dummy' terms would be most appreciated!
Many thanks for reading
Moomin