View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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.