LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"