Moving the specific word in a cell to new cell?

[ramki]

Moving the specific word in a cell to new cell? Please Help

6213_mz_abc-com-ri_sorrymom_300x250_08july08_IN.gif
6946_mz_ri_red_com_rec_yourcity_06june08.gif
6213_mz_abc-com-ri_block_728x90_08july08.swf
6214_mz_abc-com-ri_call_728x90_08july08.swf
6215_mz_abc-com-ri_dad_728x90_08july08.swf
6216_mz_abc-com-ri_doctor_blue_728x90_08july08.swf
6946_mz_abc-com-ri_found1_120x600_june08.gif
6217_mz_abc-com-RI_call_120x600_08july08.swf


I want to copy the highlighted words into next column. What is the formula. Pls. Help

[NBVC]

There doesn't seem to be any consistent pattern here... what can we use as a pattern?

Example, does the string you want always start at character # 19?

Is it (almost) always right after ri_ and do you accept some that may come back that will need manual fixes do to not falling in the decided pattern?

[Ron Coderre]

If you meant to bold "doctor_blue" in the list, then....it seems like you
want the text between the 19th character and the next subsequent numeric value.

Maybe this formula?

Please Login or Register  to view this content.

Does that help?

[NBVC]

If you meant to bold "doctor_blue" in the list, then....it seems like you
want the text between the 19th character and the next subsequent numeric value.

Maybe this formula?

Please Login or Register  to view this content.

Does that help?

That didn't work for this line:

6946_mz_abc-com-ri_found1_120x600_june08.gif

[Ron Coderre]

Thanks, my friend. THAT was an excellent catch.
I completely missed that exception.

The formula would need to be something like this:

Please Login or Register  to view this content.

[NBVC]

Very nice! Excellent fix!

although, I somehow doubt that the pattern begin always at char 20. There are too many "abc" examples and a "red" which coincidently are both 3 chars long... but the "abc" is likely a substitute for other words...

[Ron Coderre]

Please Login or Register  to view this content.

Probably true.....I just worked with the information provided.
(Plus, I needed the distraction this morning.)

A truly representative sample would give us more to work with.