formula

[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

[Dave Peterson]

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

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



Yem wrote:
>
> 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

--

Dave Peterson