MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Function help please


Posted by David S Gray on November 07, 2001 11:51 AM

Hi

Can you tell me the easiest way to extract (display) the text in a cell.

I need in a different cell all text/characters to the right of the = sign. Because they are all different lengths I cant use @left / right

EX

asgdbbd=uuwqiei
8uiue=667ywu
iiuy_88888=yyyyyy

I need everything stripped out to the right of the =

Thank


Posted by IML on November 07, 2001 11:55 AM

You could use
=LEFT(A1,FIND("=",A1)) and keep the =
or
=LEFT(A1,FIND("=",A1)-1)
to exclude the =


Posted by Dan on November 07, 2001 11:57 AM

=MID(A1,FIND("=",A1,1)+1,LEN(A1))

Assuming A1 is the cell with the data you are looking at. HTH.

Posted by IML on November 07, 2001 11:57 AM

all RIGHT

OOPS.
Make that
=LEFT(A1,LEN(A1)-FIND("=",A1)+1)
to keep the =
or
=LEFT(A1,LEN(A1)-FIND("=",A1))
to exclude it.

Posted by IML on November 07, 2001 12:03 PM

Re: all RIGHT

Okay, I just got back from a run and my brain obviously is over (under?) heated and I can't read
But
for the left with the equal, use
=LEFT(A1,FIND("=",A1)) or
=LEFT(A1,FIND("=",A1)-1) to exclude it

for the right with the qual use,
=RIGHT(A1,LEN(A1)-FIND("=",A1)+1) or
=RIGHT(A1,LEN(A1)-FIND("=",A1)) to exclude it.

Sorry for the confusion..