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..
