Extract a string using mid & find

**Queenie Balb** · 10-04-2018, 05:12 PM

Hi,
I need to extract the number of hours from a text string.
The length varies. It can be 1 to 5 digits (eg. 6hrs or 30.36667hrs).
I tried using mid and find, but need help with the length (file attached)
Thanks

**jtakw** · 10-04-2018, 05:27 PM

Hi,

Use this in I2 copied down:

Formula:

Please Login or Register  to view this content.

Results converted to Real numbers for further math/comparison, results Blank if No HRS values present, see attached.

**Queenie Balb** · 10-04-2018, 05:53 PM

Thanks Jtakw,
It works perfectly.

**alansidman** · 10-04-2018, 05:57 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**Phuocam** · 10-04-2018, 08:50 PM

Or try:

=-LOOKUP(1,-MID(H2,FIND("HRS",H2)-{1,2,3,4,5,6,7},{1,2,3,4,5,6,7}))

Extract a string using mid & find

LinkBack

Thread Tools

Rate This Thread

Display

Extract a string using mid & find

Re: Extract a string using mid & find

Re: Extract a string using mid & find

Re: Extract a string using mid & find

Re: Extract a string using mid & find

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] extract multi-letter string bits from string depending on size and case

[SOLVED] Search and Find - To extract some text from a string of text

[SOLVED] Extract all the words from a string for processing, while leaving string intact.

[SOLVED] Find and extract text string from within another text string

Find and extract text string from within another text string

[SOLVED] Extract a mainly numeric string (ISSN number) from an arbitrary string

Find String in Range and Extract

Bookmarks

Bookmarks

Posting Permissions