I have 2 cells, one has a phone number and the other has a name. Example A1 Has Phone Number B1 Name. The phone number cell has a one in front of the number (12155551212) I need to remove the 1 from it.
Any suggestions ?
I have 2 cells, one has a phone number and the other has a name. Example A1 Has Phone Number B1 Name. The phone number cell has a one in front of the number (12155551212) I need to remove the 1 from it.
Any suggestions ?
The quickest way would be to select the column,
Go to Data|Text to column..
Select Fixed Width and click next,
In the white data preview pane, click just right of the first characters. you should get a vertical bar dividing the first character from remainder of the number.
Click next.
Select first column in the data preview pane and then select Do not import from the Column Data format area and click Finish
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks