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

T

TIANA

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.
 
J

JE McGimpsey

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

Guest

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

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.
 
Top