| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell - remove a dash
Tried the find replace function....not letting me do it
"T. Valko" wrote: Select the range of cells in question Goto the menu EditReplace Find what: - Replace with: nothing, leave this empty Replace All -- Biff Microsoft Excel MVP "Shawna" wrote in message ... Hello and please help. I need to know how to change the following number in my cell from 1234-5678 to read as 12345678. Basically I want to remove the - from my number. I have over 14000 lines and each number in the column needs to have the dash remove from the number. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Display a dash | Excel Discussion (Misc queries) | |||
| remove a dash in my column | Excel Worksheet Functions | |||
| Remove dash(s) | Excel Worksheet Functions | |||
| remove a dash from part numbers | Excel Discussion (Misc queries) | |||
| Remove dash in cell | Excel Discussion (Misc queries) | |||
Threaded Mode
