ExcelBanter - Removing Hyphen(s)

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Removing Hyphen(s) (https://www.excelbanter.com/excel-worksheet-functions/258550-removing-hyphen-s.html)

Curtis[_2_]

Removing Hyphen(s)

I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks

--
ce

Pete_UK

Removing Hyphen(s)

Highlight the cells and use Find & Replace (CTRL-H) - Find hyphen and
replace with nothing.

Hope this helps.

Pete

On Mar 10, 2:49*pm, Curtis wrote:
I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks

--
ce

Iriemon

Removing Hyphen(s)

Do a find and replace (Cntrl H) and replace the "-" with nothing ("-" without
the qoutes)

"Curtis" wrote:

I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks

--
ce

All times are GMT +1. The time now is 03:01 AM.