Thread: How do I create a formula to remove dashes?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jackierae17 jackierae17 is offline
external usenet poster
  
Posts: 1
Default How do I create a formula to remove dashes?
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!!
Reply With QuoteReply With Quote