| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inconsistant character spaces extraction formula
The following type of data are listed in a column of cells:
Mon 1:30 (4:30) Mon 10 (1) Thurs 2 (5) I need to get the information in parenthasies out, into another cell. My simple extration formulas aren't working since the character spaces are inconsistent. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inconsistant character spaces extraction formula
One way:
=MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255) where 255 is just a large number If you need the value to be a number: =--MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255) In article , Sneilan wrote: The following type of data are listed in a column of cells: Mon 1:30 (4:30) Mon 10 (1) Thurs 2 (5) I need to get the information in parenthasies out, into another cell. My simple extration formulas aren't working since the character spaces are inconsistent. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inconsistant character spaces extraction formula
"Sneilan" wrote in message
... The following type of data are listed in a column of cells: Mon 1:30 (4:30) Mon 10 (1) Thurs 2 (5) I need to get the information in parenthasies out, into another cell. My simple extration formulas aren't working since the character spaces are inconsistent. Try this: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inconsistant character spaces extraction formula
This is AWESOME. Thank you!
"Stephen" wrote: "Sneilan" wrote in message ... The following type of data are listed in a column of cells: Mon 1:30 (4:30) Mon 10 (1) Thurs 2 (5) I need to get the information in parenthasies out, into another cell. My simple extration formulas aren't working since the character spaces are inconsistent. Try this: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't find why my formula is inconsistant - please help | Excel Worksheet Functions | |||
| Mystery ALT key character illudes all methods of extraction! HELP! | Excel Discussion (Misc queries) | |||
| Inconsistant Formula | Excel Discussion (Misc queries) | |||
| set column width using character spaces | Excel Discussion (Misc queries) | |||
| Replacing spaces in text, with another character | Excel Worksheet Functions | |||
Hybrid Mode
