| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA.
|
|
#2
|
|||
|
|||
|
"KimSingh" wrote
How to delete the - in (23-HFV51), I have lots of rows with data. Assume the source is in col A, A2 down Put in B2: =SUBSTITUTE(A2,"-","") Copy down Copy col B, then paste special as values to overwrite col A -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
|
#3
|
|||
|
|||
|
EditReplace
what: - with: nothing Replace all. Gord Dibben Excel MVP On Mon, 21 Mar 2005 09:07:02 -0800, "KimSingh" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Cannot delete a macro | Excel Discussion (Misc queries) | |||
| How to delete macros | Excel Discussion (Misc queries) | |||
| delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
| Saving to a network share without delete permssions | Excel Discussion (Misc queries) | |||
Linear Mode
