Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reformatting formula
I have 1 column that has a number: 11-22-3333.
Another column has the same number in a different format: 11223333 Is there a formula that will reformat one of these numbers to look like the other so I can match up additional data? |
#2
|
|||
|
|||
is the number with the dashs text or just formated with the dashes?
If it is just formated they should say they are the same if it is text and the other is a number you could use something like using in your lookup formula value(substitute(11-22-3333,"-","")) "Alicia" wrote: I have 1 column that has a number: 11-22-3333. Another column has the same number in a different format: 11223333 Is there a formula that will reformat one of these numbers to look like the other so I can match up additional data? |
#3
|
|||
|
|||
First back up your data and try this on a copy...........
Highlight the cell(s) with the numbers with the dashes in them, then Edit Replace FindWhat: - Replacewith: leave blank ReplaceAll.......... Vaya conDios, Chuck, CABGx3 "Alicia" wrote in message ... I have 1 column that has a number: 11-22-3333. Another column has the same number in a different format: 11223333 Is there a formula that will reformat one of these numbers to look like the other so I can match up additional data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |