ExcelBanter - hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. (https://www.excelbanter.com/excel-discussion-misc-queries/18562-how-delete-23-hfv51-i-have-lots-rows-data.html)

KimSingh

hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA.

Max

"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
----

Gord Dibben

EditReplace

what: -

with: nothing

Replace all.

Gord Dibben Excel MVP

On Mon, 21 Mar 2005 09:07:02 -0800, "KimSingh"
wrote:

All times are GMT +1. The time now is 02:27 AM.