Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
I have a column of numbers, all 6 digit. Some of the numbers are six digit
with a dash in between the third and fourth digit Ex. 123-456 122-451 122771 122458 233-564 ....and so on Is there a way to remove the dashes from these numbers that have dashes and leave the other ones alone? What I want is this column to not have any dashes. is concentate the formula to use?? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
On Tue, 29 Nov 2005 11:01:05 -0800, "croozer"
wrote: I have a column of numbers, all 6 digit. Some of the numbers are six digit with a dash in between the third and fourth digit Ex. 123-456 122-451 122771 122458 233-564 ...and so on Is there a way to remove the dashes from these numbers that have dashes and leave the other ones alone? What I want is this column to not have any dashes. is concentate the formula to use?? Thanks =SUBSTITUTE(A1,"-","") --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
Use find/replace:
1. Select the cells you want updated ( or the whole column) 2. Pull-down Edit Find and enter the - in the findwhat field 3. Click on the Replace tab and enter nothing in the replacewith field 4. Click Replace All -- Gary's Student "croozer" wrote: I have a column of numbers, all 6 digit. Some of the numbers are six digit with a dash in between the third and fourth digit Ex. 123-456 122-451 122771 122458 233-564 ...and so on Is there a way to remove the dashes from these numbers that have dashes and leave the other ones alone? What I want is this column to not have any dashes. is concentate the formula to use?? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
Use this formula in adjacent column, =SUBSTITUTE(A1,"-",""), where A1 contains the first value to check for dashes. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=489162 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
Wow, what a fast response, thanks a whole bunch!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Formating a number | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |