How do you format to eliminate dashes in a cell that numbers example a upc: 7-67774-54123
L learnallican1124 Mar 19, 2008 #1 How do you format to eliminate dashes in a cell that numbers example a upc: 7-67774-54123
G Gord Dibben Mar 19, 2008 #3 Maybe simply Edit>Replace What: - With: nothing Gord Dibben MS Excel MVP
S Shyam Ramachandran Mar 20, 2008 #4 CTRL F > Click REPLACE tab > In the Find what box add "-" > Leave the Replace With Field blank > Click on "Replace ALL" All the dashes will be removed. You can format the number once the dashes are removed
CTRL F > Click REPLACE tab > In the Find what box add "-" > Leave the Replace With Field blank > Click on "Replace ALL" All the dashes will be removed. You can format the number once the dashes are removed
