Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 9th 04, 01:28 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 1
Default 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/


  #2   Report Post  
Old February 9th 04, 01:35 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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/



  #3   Report Post  
Old February 9th 04, 01:39 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 3,885
Default 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!



  #4   Report Post  
Old February 9th 04, 01:40 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2003
Posts: 13
Default Deleting Hyphens or Dashes from multiple cells without deleting the remaining content

This is one way:


Set theRange = Sheet1.Range("A14") ''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/



  #5   Report Post  
Old February 9th 04, 02:16 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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!







  #6   Report Post  
Old February 9th 04, 02:59 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 1
Default Deleting Hyphens or Dashes from multiple cells without deleting the remaining content

THANK YOU SO MUCH!!!!

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent deleting multiple cells at once Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 2 October 12th 07 03:20 PM
Deleting some content of a cell PaolaAndrea Excel Discussion (Misc queries) 4 February 17th 06 08:14 AM
Deleting content alazydaydreamer Excel Worksheet Functions 3 March 22nd 05 11:57 PM
Deleting content in a column JamesBL Excel Worksheet Functions 1 November 3rd 04 12:16 AM
Deleting content in a column JamesBL Excel Worksheet Functions 1 November 2nd 04 03:21 AM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017