if a cell in Excell contains a certain word, how can I take all o.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if a cell in Excell contains a certain word, how can I take all of the words
to the right and place them in an adjacent cell.
Cell might contain "The Dark Tower: The Dark Tower VII by Stephen King"
I would like to take all the words to the right of "by" and put them in the
adjacent cell, while stripping the word "by" and the text following as well.
 
Hi

With text in A1
=LEFT(A1;FIND("by";A1)-2)
=RIGHT(A1,LEN(A1)-FIND("by",A1)-2)

Arvi Laanemets


Hamner said:
if a cell in Excell contains a certain word, how can I take all of the words
to the right and place them in an adjacent cell.
Cell might contain "The Dark Tower: The Dark Tower VII by Stephen King"
I would like to take all the words to the right of "by" and put them in the
adjacent cell, while stripping the word "by" and the text following as
Click to expand...
well.
 
Hi
try using 'Data - Text to <columns'

or for a formula trys:
=TRIM(MID(A1,FIND("by",A1)+3,1024))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Question 3
Placing word into a seperate cell 9
Excel If a Cell Contains a Certain Text (From Another Table) 0
Formatting cells containing certain words 1
Delete everything from a certain word onwards 4
How can I search for words in a list with a macro? 4
how do I extract the last three digits from each cell in column? 4
cell B1 contains a word listed in cell A1 2

Back
Top