Hi there!
I've a spreadsheet of 3500 rows that containing data that I'm preparing to import into tables in a database. Because the data was often inconsistently entered, there's a fair degree of manipulation to be done before it's ready to move to it's new home. So far (thanks to tygrrboi and Istvan Hirsch!) I've pretty much gotten the names separated and sorted out.
The next project is the phone numbers. I've manually taken care of nearly all the inconsistencies with formatting, but I'm left with one remaining issue, which sounds simple, but isn't working out the way I expected it to. I need to "pre-pend" a three-digit area code to the roughly 1500 numbers that don't already have them. In this case, it's presumed that all of the missing area codes are the same (208).
I thought I could do this with Find & Replace using wildcards (something along the lines of "find ###-#### and replace with (208) ###-####), but it doesn't seem to support wild cards. I could try to create a column of "208" and maybe use the "&" function to add the original number? But there's probably an easier way.
Any help would be appreciated!
Hm. Is "pre-pend" even a word?
I've a spreadsheet of 3500 rows that containing data that I'm preparing to import into tables in a database. Because the data was often inconsistently entered, there's a fair degree of manipulation to be done before it's ready to move to it's new home. So far (thanks to tygrrboi and Istvan Hirsch!) I've pretty much gotten the names separated and sorted out.
The next project is the phone numbers. I've manually taken care of nearly all the inconsistencies with formatting, but I'm left with one remaining issue, which sounds simple, but isn't working out the way I expected it to. I need to "pre-pend" a three-digit area code to the roughly 1500 numbers that don't already have them. In this case, it's presumed that all of the missing area codes are the same (208).
I thought I could do this with Find & Replace using wildcards (something along the lines of "find ###-#### and replace with (208) ###-####), but it doesn't seem to support wild cards. I could try to create a column of "208" and maybe use the "&" function to add the original number? But there's probably an easier way.
Any help would be appreciated!
Hm. Is "pre-pend" even a word?