refer a cell text in b1 and extract remaing text from a1

N

Narnimar

I got text in a1 like "Hydro carbon resin Petrolac 120" and in b1 like
"Petrolac 120". Now I need in c1 as "Hydro carbon resin". A formula needed to
extract the list in a with reference to list in b in c column.
 
M

Mike H

Hi,

A few examples would have helped but this works for your single example. The
second formula is dependant on the first so both will need to be entered for
this to work.

Put this in B1

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198))

and in C1

=TRIM(SUBSTITUTE(A1,B1,""))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
R

raju

Mr Mike H

Mr Narnimar want to a1 like "Hydro carbon resin Petrolac 120" and in
b1 "Petrolac 120". c1 "Hydro carbon resin". But Your formula is working only
in b1 Number & c1 is alpha. but mr narnimar want in cell c1 alpha with number.
please help him & me.
Thanks advance
raju
mumbai
 

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

Top