Hello Everyone. My name is Pete. I am new to the forum and to Excel. I hope to learn a lot here The reason I signed up is for help with my first Excel project. I am trying to extract 10 digit numbers (phone numbers without separation eg. 1234567890) and put them in an adjacent column in their respective rows. To make this even harder, there are 2 columns where the phone numbers may be, and sometimes 2 phone numbers. I am attaching an example. The password is "excelforum.com" Thanks! Glad you guys are here.
Edit: I just noticed some have dashes eg. 123-456-7890 and some have commas next to the number eg. 1234567890,
Bookmarks