How do I delete a character from a list of item numbers?
 

I have a list of item numbers in a column that have a dash in different
locations within the number, I would like to get rid of the dashes.

Select your column and do a Find/Replace, with the dash in the Find:
box, leaving the Replace with: box blank.

In article ,
"TIANA" wrote:

I have a list of item numbers in a column that have a dash in different
locations within the number, I would like to get rid of the dashes.

Hi
Try Find/Replace. In the Find box put your dash - and leave the
Replace box blank.

--
Andy.


"TIANA" wrote in message
...
I have a list of item numbers in a column that have a dash in different
locations within the number, I would like to get rid of the dashes.

Select the list, then:

<Edit <Replace

In the "Find What" window, enter your dash.

Leave the "Replace With" window empty,

And just click "Replace All".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"TIANA" wrote in message
...
I have a list of item numbers in a column that have a dash in different
locations within the number, I would like to get rid of the dashes.