| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing digits in a cell
I have telephone numbers listed in a column and need to change the area code and the 3 digit exchange. example: 5555555555 to (444)444-5555. please help -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
Hi Hemming,
If your data is located in cell A1, this formula : ="("&LEFT(A1,3)&")"&MID(A1,4,3)&"-"&RIGHT(A1,4) should do the job ... HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
Hi Carim, thanks for the help, it almost worked..... this works great if I only have one cel to change however I have an entire Column how do I change it to change more than one cell ( each cell has a different last 4 digits ) -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
can anyone help me with this ,,,,it is driving crazy !! thanks -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
"Hemming" wrote in
message ... can anyone help me with this ,,,,it is driving crazy !! thanks If you have to change them all to the same area code and exchange, I'd use this formula in another column: if cell A1 is: 5555555555 put this in cell A2: =value("444444" & right(a1,4)) Then you get a number in A2, which you can format as a Phone Number (using Format/Cells/Number/Special/Phone Number). HTH, Don -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
can this be used in a macro ????? -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing digits in a cell
"Hemming" wrote in
message ... can this be used in a macro ????? It could be, but, for changing the values in a single column, it's simplest and quickest just to write a formula (using relative cell addressing), format it properly, and copy it down all the rows. HTH, Don -- Hemming ------------------------------------------------------------------------ Hemming's Profile: http://www.excelforum.com/member.php...o&userid=32185 View this thread: http://www.excelforum.com/showthread...hreadid=519308 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| number changing digits on paste from web apx file field | Excel Discussion (Misc queries) | |||
| Changing digits in a cell HELP | Excel Discussion (Misc queries) | |||
| Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
| changing 4 digits into 2 digit year | Excel Programming | |||
Linear Mode
