View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Persheff Chris Persheff is offline
external usenet poster
 
Posts: 1
Default 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!