donlincolnmre2
Board Regular
- Joined
- Dec 23, 2006
- Messages
- 142
Hello
I have a sheet that contains data in column B with text and phone numbers.
I’m looking to extract the phone numbers from column B and place it, in a BLANK ROW UNDER in column A and then delete that number from column B and then copy the row which had the number right next to the phone number where the number was placed, AS SHOWN IN THE FOLLOWING Google sheet link.
Any help will be greatly appreciated J
Thanks.
I have a sheet that contains data in column B with text and phone numbers.
I’m looking to extract the phone numbers from column B and place it, in a BLANK ROW UNDER in column A and then delete that number from column B and then copy the row which had the number right next to the phone number where the number was placed, AS SHOWN IN THE FOLLOWING Google sheet link.
Extract Phone Numbers
Sheet1 To Process (334) 329-7100,2101 E University Dr. Auburn, AL 36830-3334. ... Bakersfield, CA 93312-3209. 661-589-4400. Drywall. (209) 408-8466,Vega, Ceres (CA) • Age: 48, , 3600 ... 831-722-4757,Arredondo:, Watsonville CA, 334 Buena Vista Dr ... 661-951-0808,P.O. BOX 1995 LANCASTER, CA 93...
docs.google.com
Any help will be greatly appreciated J
Thanks.