Extracting information from text within a cell

Try these:

In B1:

Please Login or Register  to view this content.

In C1:

Please Login or Register  to view this content.

in D1:

Please Login or Register  to view this content.

each copied down

Ah. I can see what you have done here. Hmmm. This assumes that each textblock carries only 3 types of data (Work:, Information and Time: ). What I gave here was a shortened list though, the real list im working on have 13 types. Your way might be the only solution to extract data from the types which contains text though.

Your solution is fairly similar to my solution for the numbers.

=VALUE(IF(COUNTIF($C117;CONCATENATE("*";I$115;"*"))>0;MID($C117;FIND(I$115;$C117;1)+5;2);0))

Note VALUE( and 2. Since I know that there's either one or two digits, 2 is enough when not dealing with text. VALUE( is used to clear out a comma if there's only 1 digit (#,).

$C117 is the cell that contains the textblock.
I$115 is a cell that contain the kind of information to search for (Such as "Work: " or "Time: ").