Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of Symbol and Character Number | Excel Discussion (Misc queries) | |||
How can I set up to chose more than 1 item from a dropdown list (. | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Lists: Clicking on one item in one list and getting certain info i | Excel Worksheet Functions |