Return the string between two character numbers

[rhua5436]

Hi everyone,

I would like to find out how I can return a string between two specific character numbers.

Example,

Apple Pear Cider

I know "apple" in my cell starts in the 15th character & Cider starts as the 26th character, how do I return the pear string?


Thank you!

[rhua5436]

in addition, the length of the string using pear as an example varies. might be 8 characters long etc.
But I would definitely know the character positions of apple and cider using search function.
How do I return that string in the middle?

thank you!

[Alf]

If you know the position of the first character in apple (say 15) and the first character in cider (26) then a function like:

Please Login or Register  to view this content.

should do the trick.

If you want a more complex formula that just determins the position of apple and cider and then cut out the string between you could try:

Please Login or Register  to view this content.

Both formulas assumes that your string is found in cell D4.

Alf

[rhua5436]

thank you so much!