need help extracting data from cell....
 

Hi - I've never used VBScript before.

I need to get the data within the parentheses.

"222 134 STREET
New York, NY 10030
(40.8149219739981, -73.94493618207292)"

and put it in another column.

I would like a formula or process to do this to multiple cells, going down.

Thanks!

need help extracting data from cell....
 

hi Chris,

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")


--
isabelle

need help extracting data from cell....
 

or,

=IF(ISERROR(FIND("(",A1)),A1,LEFT(A1,FIND("(",A1)-1))


--
isabelle


Le 2011-10-19 14:33, isabelle a écrit :
hi Chris,

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

need help extracting data from cell....
 

On Oct 19, 1:36*pm, isabelle wrote:
or,

=IF(ISERROR(FIND("(",A1)),A1,LEFT(A1,FIND("(",A1)-1))

--
isabelle

Le 2011-10-19 14:33, isabelle a écrit :







hi Chris,

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

OR withOUT formulas, Just use datatext to columnsdelimitedother (

need help extracting data from cell....
 

On Wed, 19 Oct 2011 09:38:34 -0700 (PDT), Chris Persheff wrote:

Hi - I've never used VBScript before.

I need to get the data within the parentheses.

"222 134 STREET
New York, NY 10030
(40.8149219739981, -73.94493618207292)"

and put it in another column.

I would like a formula or process to do this to multiple cells, going down.

Thanks!


For a worksheet formula, with your data in A1:

B1: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

and fill down.

need help extracting data from cell....
 

On Oct 19, 11:38*am, Chris Persheff wrote:
Hi - I've never used VBScript before.

I need to get the data within the parentheses.

"222 134 STREET
New York, NY 10030
(40.8149219739981, -73.94493618207292)"

and put it in another column.

I would like a formula or process to do this to multiple cells, going down.