Linking and unlinking data in a single field
Posted by H on November 15, 2001 8:33 AM
I have a problem where I have two spreadsheets different files. within them I have one field and they are phone numbers. Spreadsheet 1 has the phone number in the following format
Spreadsheet two has it in the following format
How can I get either spreadsheet 1 to look like spreadsheet 2 or vice a verse (so basically I want to either add or take away a space between the area code and number)? Is there a simple way of doing this.
spreadsheet 1 = 024 76222222
spreadsheet 2 = 024 76222222
spreadsheet 1 = 02476222222
spreadsheet 2 = 02476222222
The purpose of this is so i can insert it into 1 table and do a search.
Thanks for your help.