How to remove dashes and slashes form a sequence of numbers & lett

  • Thread starter Thread starter Celticshadow
  • Start date Start date
C

Celticshadow

Hi

I have a sequence of numbers in column D and I require to extract just the
numbers and letters to column E.

D
190/0-01
31-0014
pp7/44-1
uf-744-5

E
190001
310014
pp7441
uf7445

Any pointers would be much appreciated.

Kind Regards

Celticshadow
 
Put this in E1:

=SUBSTITUTE(SUBSTITUTE(D1,"/",""),"-","")

and copy down as required.

Hope this helps.

Pete
 
Dear Pete

Brilliant and thank you very much, works a treat.

What a great bunch of pleasant folk you all are. I do hope people do not get
fed up with me continually asking questions.

Kind Regards

Celticshadow
 
Back
Top