need help extracting data from cell....

[Chris Persheff]

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!

 

[isabelle]

hi Chris,

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

 

[isabelle]

or,

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

 

[Don Guillett]

or,

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

OR withOUT formulas, Just use data>text to columns>delimited>other (

 

[Don Guillett]

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!

Just use data>text to columns>delimited> (