highlight the column header (ie C)editreplace - blank

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jackierae17" wrote in message
...
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!!