How do I create a formula to remove dashes?
I have the perfect solution for you and it involves two easy steps:
(1) You will use the TEXT TO COLUMNS function to separate each set as : V1
in one column, 25 in another column, F in another column, 2E in another
column, etc. (Data: Text to Columns click on "Delimited"select a delimiter:
"Other" and type a dash in it (-); click NEXT; click FINISH (this will
separate or parse your data).
(2) Now you want all of these pieces in one column, so use this function:
ampersand.
What you do is, go to the cell where you want your set of data, type "=",
click on the cell where you have the "V1" and type "&" in the formula, now
click on the cell where you have "25 and type "&", and so on forth until you
get your final product: "V125F2E".
Roxana
"jackierae17" wrote:
I'm new to Excel. I have a huge inventory spreadsheet where I need to change
a column to reflect the following.
"P01-02-C-1" should become "P102C1" (remove 0 and dashes)
"V1-25-F-2E" should become "125F2E" (remove V and dashes)
HELP!!
|