Posted to microsoft.public.excel.misc

Sneilan

external usenet poster

Posts: 3

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I can't find why my formula is inconsistant - please help	Kath	Excel Worksheet Functions	7	July 16th 06 02:22 PM
Mystery ALT key character illudes all methods of extraction! HELP!	bxc2739	Excel Discussion (Misc queries)	6	March 16th 06 08:12 PM
Inconsistant Formula	nastech	Excel Discussion (Misc queries)	3	March 3rd 06 04:51 AM
set column width using character spaces	Troy \| yorT	Excel Discussion (Misc queries)	3	February 26th 06 11:49 AM
Replacing spaces in text, with another character	PCLIVE	Excel Worksheet Functions	2	October 14th 05 06:43 PM

All times are GMT +1. The time now is 04:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us