formula

Y

Yem

Hi,

I have a problem.
I have in column A a system tag 202.E.0716/LN114-01. I want another column
to automatically give me 202E0716LN11401.
I have more than 1000 points in my list and I dont want to manually type the
all the points.
Thanks in advance.

Yem
 
D

Dave Peterson

If you only have to get rid of the dots and dashes, you could use a formula
like:

=SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")
 
Top