conditional formatting to count characters in a cell

Hello everybody!
I'm desperate for help since I was looking for the solutions for hours today.
I have a cell with a key (example > fgrjwyd%fnksdf%) and then equal a text (example > read your book)

So in this example the cell contains>
fgrjwyd%fnksdf%=read your book

How can I do to count the characters of the text only ? (limit would be the = sign)

Thank you!

I think you want

=LEN(A2)-FIND("=",A2)

A2 contains the "fgrjwyd%fnksdf%=read your book" and result is 14 (the length of "read your book")

Hi,

So you want the # of characters before the "="?

=FIND("=",A1,1)-1

HTH
Steve

Hello Cutter, SteveG,

First of all, thank you both for your quick help !!! It is very appreciated!
Yes, that's what I needed! the answer in that case is 14.
So cool, you rock

lol, Like Steve, I calculated the KEY on the left of the = sign.

>_<

=SEARCH("=",G36)-1

You're welcome. Don't forget to mark your thread as SOLVED (for instructions click on Forum Rules @ top of page - see rule #9).