donlincolnmre
New Member
- Joined
- Jun 11, 2005
- Messages
- 46
Hello.
I have a spreadsheet in COLUMN A it contains mix data, It has 7 and 10 digits phone number and some rows have text and some date and some unmeaningfull data. I need to extract 7 and 10 digits phone number from coulumn A and put it in Coulmn B. I have posted an sample spred sheet, as you can see ROW 3051 have phone number and some data to it and row 3056 have the same problem. so i need to extract those phone nubmers
Thanks.
here is the sample data.
I have a spreadsheet in COLUMN A it contains mix data, It has 7 and 10 digits phone number and some rows have text and some date and some unmeaningfull data. I need to extract 7 and 10 digits phone number from coulumn A and put it in Coulmn B. I have posted an sample spred sheet, as you can see ROW 3051 have phone number and some data to it and row 3056 have the same problem. so i need to extract those phone nubmers
Thanks.
here is the sample data.
Expired Phone Extractor.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3043 | 11/2/ | |||||
3044 | 7149935165 | |||||
3045 | 11/1/ | |||||
3046 | 6196241038 | |||||
3047 | withher,callon1117.11/2/ | |||||
3048 | 9098824592 | |||||
3049 | 11/2/ | |||||
3050 | 9097904440 | |||||
3051 | 4540350.LandvoiceLeads | |||||
3052 | VisitthewebsiteunderourConferenceCallsectiontoseetheschedule | |||||
3053 | 3238710329.Untitled | |||||
3054 | LandvoiceLeads | |||||
3055 | 10/30/ | |||||
3056 | 7607423289 LandvoiceLeads | |||||
3057 | 9092411298 | |||||
3058 | 1108,IsamsyriaDavidamericannamehe | |||||
3059 | 10/29/ | |||||
3060 | 5417632 | |||||
3061 | 10/29/ | |||||
3062 | 2471956 | |||||
3063 | 10/28/ | |||||
3064 | 7143565111 1108,IsamsyriaDavidamericannameh | |||||
press Ctrl t as soon as you ope |