| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help extracting data from cell....
hi Chris,
=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","") -- isabelle |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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,"(",""),")","") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ( |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Data From The Right of a Cell | Excel Worksheet Functions | |||
| extracting data from one cell to another | Excel Worksheet Functions | |||
| Extracting data from a cell | Excel Worksheet Functions | |||
| Extracting data from a cell | Excel Discussion (Misc queries) | |||
| Extracting data from a cell - please help | Excel Discussion (Misc queries) | |||
Linear Mode
