Mark K
05-01-2018, 12:42 PM
Hello!
First time 'poster', long-time lurker/searcher. For a beginner in VBA, I think I have a pretty lofty goal.
I have searched for the better part of two days in an attempt to locate vba that I can piece together to accomplish my goal but I have not had any luck.
I would like any cell in 'A' with a string length less than 10 (ie: a valid phone number) to have the row deleted and the remaining rows shifted up.
Column B: I would like to have a '1' placed in front of the remaining numbers that don't have a '1' and placed in column B.
Column C: I would like to have the area code placed in paren's and placed in column C with displayed formatting (removing the prefix '1' if present).
Column D: Valid phone numbers with the prefix '1' removed and placed in 'D'.
I hate having to ask someone to essentially 'do the work', but I'm so new to this that I don't know where to start. Thanks for any help!!
Sample file is attached.
First time 'poster', long-time lurker/searcher. For a beginner in VBA, I think I have a pretty lofty goal.
I have searched for the better part of two days in an attempt to locate vba that I can piece together to accomplish my goal but I have not had any luck.
I would like any cell in 'A' with a string length less than 10 (ie: a valid phone number) to have the row deleted and the remaining rows shifted up.
Column B: I would like to have a '1' placed in front of the remaining numbers that don't have a '1' and placed in column B.
Column C: I would like to have the area code placed in paren's and placed in column C with displayed formatting (removing the prefix '1' if present).
Column D: Valid phone numbers with the prefix '1' removed and placed in 'D'.
I hate having to ask someone to essentially 'do the work', but I'm so new to this that I don't know where to start. Thanks for any help!!
Sample file is attached.