I am attempting to select text between specified text, as indicated at<a href="https://www.extendoffice.com/documents/excel/5103-excel-extract-between-two-characters.html#a3" target="_blank" rel="nofollow noreferrer">https://www.extendoffice.com/documents/excel/5103-excel-extract-between-two-characters.html#a3</a> 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

Nghastell Newydd Emlyn

Problem Echdynnu Testun o Rhwng Testun Penodedig

Kutools ar gyfer Excel

Defnyddiwr Anhysbys

Dydd Llun, 13 2022 Mehefin

2 atebion

Ymweliadau 5.3K

Pleidleisiau

Dadwneud

Rwy'n ceisio dewis testun rhwng testun penodedig, fel y nodir ynhttps://www.extendoffice.com/documents/excel/5103-excel-extract-between-two-characters.html#a3

Yn anffodus, gan ddilyn y cyfarwyddiadau, nid yw'n ymddangos bod y fformiwla'n gweithio ac eithrio os yw'r testun dan sylw ar ddechrau'r llinyn.

The formula provided by Kutools Formula Helper is:

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

Ac mae i fod i ddewis testun rhwng "Fformat:" a'r coma nesaf yn y llinyn. Fodd bynnag, oni bai bod y llinyn yn dechrau gyda "Fformat:" nid yw'n dychwelyd dim.

Felly er enghraifft mae'n gweithio'n iawn gyda'r llinyn hwn:

Fformat: llyfr, Awdur: Tolkien

ond mae'n methu gyda'r llinyn hwn:

Awdur: Tolkien, Fformat: Llyfr

Sunny

1 flwyddyn yn ôl

#2790

Pleidleisiau

Dadwneud

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. dyfyniad rhwng.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.

garkbeda43

1 flwyddyn yn ôl

#2822

-1

Pleidleisiau

Dadwneud

diolch am eich adborth.

Tudalen:
1

Ni wnaed unrhyw atebion i'r swydd hon eto.

Mewngofnodi i bostio ateb

Bydd angen i chi fewngofnodi i allu postio ateb. Mewngofnodi gan ddefnyddio'r ffurflen ar y dde neu gofrestru cyfrif os ydych chi'n newydd yma. Cofrestrwch Yma »