Winston618
Member
I have the below data on 3 different cell and I would like to extract the text string Book, Booklet & CD from each cell.
Data:
A1 = 1 sound disc (ca. 17 min.) : digital ; 4 3/4 in. + 1 book (31 p. : col. ill. ; 18 cm.)
A2 = 1 sound disc (ca. 14 min.) : digital ; 4 3/4 in. + 1 booklet
A3 = 1 sound disc (ca. 26 min.) : digital ; 4 3/4 in. + 1 CD
For the ease of my understanding, I split the formula into two parts.
First, I apply the following formula:
to locate the first cell and get book (31 p. : col. ill. ; 18 cm.)
Second, I use formula:
to reference the first formula and get the word book successfully. However the formula doesn't apply to the second and the third cell and I have been working on it for hours.
Please find the attached file for better understanding
Am I missing something? Please help, thanks!
Data:
A1 = 1 sound disc (ca. 17 min.) : digital ; 4 3/4 in. + 1 book (31 p. : col. ill. ; 18 cm.)
A2 = 1 sound disc (ca. 14 min.) : digital ; 4 3/4 in. + 1 booklet
A3 = 1 sound disc (ca. 26 min.) : digital ; 4 3/4 in. + 1 CD
For the ease of my understanding, I split the formula into two parts.
First, I apply the following formula:
Code:
B1 =(MID(A1,FIND("+ 1",A1)+4,256))
Second, I use formula:
Code:
C1 =LEFT(B1,FIND(" ",B1)1)
Please find the attached file for better understanding
Am I missing something? Please help, thanks!
Attachments

26.5 KB Views: 7