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

[Guest]

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.

 

[JE McGimpsey]

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

 

[Guest]

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

 

[RagDyeR]

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!
==============================================

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.