I have a long list of information that looks like this:
A1: Work: 8, Information: Yes indeed
A2: Work: 19, Information: Circular, Time: 1
A3: Information: Sort of, Time: 20
What I would like to do is to be able to extract the information into separate cells without editing the text manually:
B1: 8 C1: Yes Indeed D1: 0
B2: 19 C2: Circular D2: 1
B3: 0 C2: Sort of D3: 20
Or be able to match information within the text:
IF A2 work > 10 THEN TRUE
There's a function that extracts text that can be combined with find, but it forces me to type how many letters I wish to extract. If I use 7 letters for "information" I would get:
Yes ind
Circula
Sort of
Any idea upon how I can solve this?
Bookmarks