Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a dash from part numbers
I have a database that have part number with dashes (ex. AX-2912) is there
a way to remove the dash? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a dash from part numbers
You could use Find/Replace. Find - and leave the Replace With field blank.
Or, you could set up a formula in an adjacent column. =SUBSTITUTE(A1,"-","") HTH, Elkar "Mr Happy" wrote: I have a database that have part number with dashes (ex. AX-2912) is there a way to remove the dash? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a dash from part numbers
You can do it with a formula:
=SUBSTITUTE(A1,"-","") If you need VBA code to loop through an entire range, use Sub AAA() Dim Rng As Range For Each Rng In Selection.Cells Rng.Value = Replace(Rng.Text, "-", "") Next Rng End Sub Select the cells with the dashes and then run the code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mr Happy" <Mr wrote in message ... I have a database that have part number with dashes (ex. AX-2912) is there a way to remove the dash? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a dash from part numbers
Thank you both.
"Elkar" wrote: You could use Find/Replace. Find - and leave the Replace With field blank. Or, you could set up a formula in an adjacent column. =SUBSTITUTE(A1,"-","") HTH, Elkar "Mr Happy" wrote: I have a database that have part number with dashes (ex. AX-2912) is there a way to remove the dash? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Vlookup referencing one column that contains part numbers in both. | Excel Worksheet Functions | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |