ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting Hyphens or Dashes from multiple cells without deleting the remaining content (https://www.excelbanter.com/excel-programming/290674-deleting-hyphens-dashes-multiple-cells-without-deleting-remaining-content.html)

rmaloy

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
I have a column in excel that has a list of circuit id's. All of these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of the
hyphens/dashes, without having to go into each cell individually? I
still need the characters to remain in order, just without the hyphens.
(Ex. 1344M1210001, 1344M12100001)

Thanks!


---
Message posted from http://www.ExcelForum.com/


Tom Ogilvy

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
As long as there are letters in the sequences,

Select all the cells or an area that contains all the cells but not hyphens
you do not want to delete.

then do Edit=Replace

Replace What: =

Replace With: ' leave blank

Then click OK

--
Regards,
Tom Ogilvy


rmaloy wrote in message
...
I have a column in excel that has a list of circuit id's. All of these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of the
hyphens/dashes, without having to go into each cell individually? I
still need the characters to remain in order, just without the hyphens.
(Ex. 1344M1210001, 1344M12100001)

Thanks!


---
Message posted from http://www.ExcelForum.com/




Frank Kabel

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
Hi
try 'Search and Replace' from the Edit menu

Frank

I have a column in excel that has a list of circuit id's. All of

these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of
the hyphens/dashes, without having to go into each cell individually?
I still need the characters to remain in order, just without the
hyphens. (Ex. 1344M1210001, 1344M12100001)

Thanks!




Ray at[_2_]

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
This is one way:


Set theRange = Sheet1.Range("A1:D4") ''your range here
For Each oCell In theRange
oCell.Value = Replace(oCell.Value, "-", "")
Next
Set theRange = Nothing

--

Ray at home
Microsoft ASP MVP


"rmaloy " wrote in message
...
I have a column in excel that has a list of circuit id's. All of these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of the
hyphens/dashes, without having to go into each cell individually? I
still need the characters to remain in order, just without the hyphens.
(Ex. 1344M1210001, 1344M12100001)

Thanks!


---
Message posted from http://www.ExcelForum.com/




Tom Ogilvy

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
Just for interest.
In the US menu structure it is just Edit=Replace

--
Regards,
Tom Ogilvy


Frank Kabel wrote in message
...
Hi
try 'Search and Replace' from the Edit menu

Frank

I have a column in excel that has a list of circuit id's. All of

these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of
the hyphens/dashes, without having to go into each cell individually?
I still need the characters to remain in order, just without the
hyphens. (Ex. 1344M1210001, 1344M12100001)

Thanks!






rmaloy[_2_]

Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
 
THANK YOU SO MUCH!!!!

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com