ExcelBanter - eliminate dashes in upc's

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - eliminate dashes in upc's (https://www.excelbanter.com/new-users-excel/180627-eliminate-dashes-upcs.html)

learnallican1124

eliminate dashes in upc's

How do you format to eliminate dashes in a cell that numbers example a upc:

7-67774-54123

JP[_4_]

eliminate dashes in upc's

If the UPC is in cell A1:

=SUBSTITUTE(A1,"-","")

HTH,
JP

On Mar 19, 10:22*am, learnallican1124
wrote:
How do you format to eliminate dashes in a cell that numbers example a upc:

7-67774-54123

Gord Dibben

eliminate dashes in upc's

Maybe simply EditReplace

What: -

With: nothing

Gord Dibben MS Excel MVP

On Wed, 19 Mar 2008 07:22:01 -0700, learnallican1124
wrote:

How do you format to eliminate dashes in a cell that numbers example a upc:

7-67774-54123

Shyam Ramachandran

eliminate dashes in upc's

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

"learnallican1124" wrote:

How do you format to eliminate dashes in a cell that numbers example a upc:

7-67774-54123

All times are GMT +1. The time now is 04:22 AM.