Eliminate partial string

[an]

Hello!

I have:

CBO5 (mg/l)
CE (uS/cm 25ºC)
CH4
cis - 1,2-dicloroeteno (µg/l)

I would like to eliminate all characters to 1st (
(to keep units only)

Is it possible in Excel2K?
Thanks in advance.
an

 

[Andy B]

Hi

You could use a helper column alongside your data with:
=MID(A1,FIND("(",A1),999)

--
Andy.


Hello!

I have:

CBO5 (mg/l)
CE (uS/cm 25ºC)
CH4
cis - 1,2-dicloroeteno (µg/l)

I would like to eliminate all characters to 1st (
(to keep units only)

Is it possible in Excel2K?
Thanks in advance.
an

 

[an]

Ok, Andy B,

Many thanks for your replay.
an