I have a spreadsheet that was created from a database export. One of the fields/cells contains multiple telephone numbers and alpha descriptors. The formatting is not consistent and there can be 1 phone number or 15 listed. Most multiple numbers are separated by a carriage return, rather than a space. The good thing is that all the phone numbers have the same formatting (xxx-xxx-xxxx) which I'm hoping will make it easier.
I would like to learn how to delete the alpha characters and be left with phone numbers separated with ANY character.
Once that is completed, I will attempt to use one of the other formulas I found on this site (awesome) to split the phone numbers into separate rows.
I've attached a sample spreadsheet (At least I hope it is - new to the forum!). The Column I'm looking at is the CKT NO
Thank you so much!
Janet
Bookmarks