Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Anonymous User
  Monday, 13 June 2022
  2 Replies
  4.8K Visits
0
Votes
Undo
I am attempting to select text between specified text, as indicated athttps://www.extendoffice.com/documents/excel/5103-excel-extract-between-two-characters.html#a3

Unfortunately, following the instructions, the formula does not seem to work except if the text in question is at the very beginning of the string.

The formula provided by Kutools Formula Helper is:

=IFERROR(MID(I3,FIND("Format:",I3)+LEN("Format:"),FIND(",",I3)-FIND("Format:",I3)-LEN("Format:")), "")

And it is meant to select text between "Format:" and the next comma in the string. However unless the string begins with "Format:" it returns nothing.

So for instance it works fine with this string:

Format: book, Author: Tolkien

but it fails with this string:

Author: Tolkien, Format: Book
1 year ago
·
#2822
-1
Votes
Undo
thanks for your feedback.
1 year ago
·
#2790
0
Votes
Undo
Hi, Tolkien, thanks for your feedback. Firstly, the Excel formula =MID(LEFT(A1,FIND("end_char",A1)-1),FIND("start_char",A1)+1,LEN(A1)) only can extract text string between two single characters. And the Formulas Helper of Kutools for Excel, I have tested in Excel 2019, 2021 and Office 365, it can extaract string between "Format:" and "," whatever if the string is begins with "Format:", please see the screenshot attached. extract between.png
Could you tell me which Excel version you use? Amd should you upload the data and formula result screenshot for me to better realized the problem? Thank you.
Attachments (1)
  • Page :
  • 1
There are no replies made for this post yet.