MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking numbers or unlinking them? Please help

Posted by H on November 15, 2001 1:55 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

(024) 76222222

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.

Example 1

spreadsheet 1 = (024) 76222222

spreadsheet 2 = (024) 76222222

Thanks for your help.


Posted by Aladin Akyurek on November 15, 2001 3:09 AM


=SUBSTITUTE(A1,LEFT(A1,3),"("&LEFT(A1,3)&") ")

in order to convert 02476222222 to (024) 76222222.