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.