Eliminate partial string

  • Thread starter Thread starter an
  • Start date Start date
A

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
 
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
 
Back
Top