Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format the phone number
Hi,
Can any one tell me how to get rid off the "-" at end of the data (downloaded from SAP). The data I download from SAP look like this (203) 968-7273-. I would like to get rid off the "-" at the end to make my work sheet looks better. I have over a thousand rows, so it is almost impossible to do it manually. Thanks, Mickie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
phone number format | Excel Worksheet Functions | |||
phone number format | Excel Discussion (Misc queries) | |||
Changing Phone number format | Excel Worksheet Functions | |||
How to format a phone number in Excel | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) |