I have an oddball request. I have a 9k line spreadsheet with phone numbers list as one 10-character string of digits. I need to separate the area code and 7-digit number. The 7-digit number needs to be moved to the adjaced column to the right.
I have tried writing the VBA for this, but I keep getting something terribly wrong, because it just locks-up Excel.
By the way, I am using Excel 2007.
TIA!
I have tried writing the VBA for this, but I keep getting something terribly wrong, because it just locks-up Excel.
By the way, I am using Excel 2007.
TIA!