• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Test Formula

S

sachar

Member
Dear Troubleshooter,

Can you explore the formula =RIGHT (B2, LEN (B2) -FIND (",", B2) -0)
Which is applied to the attached file?
 
in case you need explanation, here is the start up:

Text in B2="*Tritsmans,Eline,Ms."


=RIGHT(TEXT,NUM_CHARS)

Separate remaining formulas and note the result:
1)
LEN("*Tritsmans,Eline,Ms.")=20

2)
FIND(",","*Tritsmans,Eline,Ms.") = 11

3)
=RIGHT("*Tritsmans,Eline,Ms.",20-11)
=RIGHT("*Tritsmans,Eline,Ms.",20-11)

Finally =RIGHT("*Tritsmans,Eline,Ms.",9)

="Eline,Ms."
 
Dear Sir,

Received with thanks, the almost my problem is solved, but, I could not make the sense of {","} this command in this formula.

FIND(
","[/QUOTE],"*Tritsmans,Eline,Ms.") = 11
Click to expand...
 
Hi,
Glad your problem is solved,

Actually you are finding the comma in text string, so you can separate names.

See how find formula works:
find formula returns the starting position of text to be found
=FIND("find_text",within_text)

so 1st we mention the comma "," in find_text field
and cell B2 (which contains the text) in within_text field

=FIND(",",B2)
=FIND(",","*Tritsmans,Eline,Ms.")

You can see the comma "," in *Tritsmans,Eline,Ms. is at 11th position.
eg.
*=1st
T=2nd
r=3rd
i=4th
t=5th
s=6th
m=7th
a=8th
n=9th
s=10th
and comma "," is at 11th possition

Hence, it will return 11.
 
Dear sir,
Thanks to answer in details, may I know what will be written in "find text" when we want to know the ending position of text?

=FIND("find_text",within_text)
 
You must log in or register to reply here.
Back
Top