jillrussell
New Member
- Joined
- Jul 21, 2008
- Messages
- 8
I have a spreadsheet of 138 phone #'s (including area codes).
About 10 of the #'s have a letter in them (i.e. 734-R42-7422) (and no, I can't just change the R to "7" - that would be too easy)
Obviously, since they have both text and numerical characters, they won't format properly as phone numbers.
Does anyone know how can I format them to show as phone #'s ?
About 10 of the #'s have a letter in them (i.e. 734-R42-7422) (and no, I can't just change the R to "7" - that would be too easy)
Obviously, since they have both text and numerical characters, they won't format properly as phone numbers.
Does anyone know how can I format them to show as phone #'s ?