View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clare
 
Posts: n/a
Default Merging info from 5 cells to 1

I have a number 21-/A/-525-/E/-0001 the / represent the cells, I want it in
one cell to look like 21-A-525-E-0001. We I concatenate or use & it removes
the dashes and turns 0001 into 1. Does anyone have any suggestions?