Code

[alliswell]

ROYALKINGS where
R=1,O=2,Y=3,A=4,L=5,K=6,I=7,N=8,G=9,S=0
Now whenever i type any code for example when i put YLS in a1 i should get 350 in b1 coz y=3, L=5, s=0
I dont want macro. Some formula function or trick.

Thanks n regards
Love u all

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[alliswell]

Dear fluff in my last question you replied me with solution using office 365 and its working very fine. Below was my question i asked.

ROYALKINGS where
R=1,O=2,Y=3,A=4,L=5,K=6,I=7,N=8,G=9,S=0
Now whenever i type any code for example when i put YLS in a1 i should get 350 in b1 coz y=3, L=5, s=0
I dont want macro. Some formula function or trick

This was your reply
=CONCAT(RIGHT(SEARCH(MID(A1,SEQUENCE(LEN(A1)),1),"royalkings")))

Just need to know the use of MID and RIGHT. Can you please elaborate ? Only applying formula is not ok na i need to know so that i can understand.

Thanks n Regards

 

[Joe4]

Note I have moved your post in to your original thread. If you have a follow-up question about a reply, you will want to post it back to the original thread. Otherwise, there is a good chance that the person who are trying to get the attention of may never see it!

 

[alliswell]

Note I have moved your post in to your original thread. If you have a follow-up question about a reply, you will want to post it back to the original thread. Otherwise, there is a good chance that the person who are trying to get the attention of may never see it!

Dear fluff in my last question you replied me with solution using office 365 and its working very fine. Below was my question i asked.

ROYALKINGS where
R=1,O=2,Y=3,A=4,L=5,K=6,I=7,N=8,G=9,S=0
Now whenever i type any code for example when i put YLS in a1 i should get 350 in b1 coz y=3, L=5, s=0
I dont want macro. Some formula function or trick

This was your reply
=CONCAT(RIGHT(SEARCH(MID(A1,SEQUENCE(LEN(A1)),1),"royalkings")))

Just need to know the use of MID and RIGHT. Can you please elaborate ? Only applying formula is not ok na i need to know so that i can understand.

Thanks n Regards

 

[alliswell]

Dear fluff in my last question you replied me with solution using office 365 and its working very fine. Below was my question i asked.

ROYALKINGS where
R=1,O=2,Y=3,A=4,L=5,K=6,I=7,N=8,G=9,S=0
Now whenever i type any code for example when i put YLS in a1 i should get 350 in b1 coz y=3, L=5, s=0
I dont want macro. Some formula function or trick

This was your reply
=CONCAT(RIGHT(SEARCH(MID(A1,SEQUENCE(LEN(A1)),1),"royalkings")))

Just need to know the use of MID and RIGHT. Can you please elaborate ? Only applying formula is not ok na i need to know so that i can understand.

Thanks n Regards

Can anybody answer please ?

 

[Fluff]

The best way to find out what a formula is doing is to use the Evaluate Formula feature on the Formula tab.
The MID function splits the value in A1 into it's individual letters, the SEARCH then returns the position of the letters in the word RoyalKings.
As RoyalKings is 10 characters long the S will return 10 rather than 0 so RIGHT is used to just return the last digit of that number.

 

[alliswell]

The best way to find out what a formula is doing is to use the Evaluate Formula feature on the Formula tab.
The MID function splits the value in A1 into it's individual letters, the SEARCH then returns the position of the letters in the word RoyalKings.
As RoyalKings is 10 characters long the S will return 10 rather than 0 so RIGHT is used to just return the last digit of that number.

Thankyou fluff bro. Got it. Thanks & love ya bro

 

[Fluff]

You're welcome.

 

[alliswell]

You're welcome.

Dear fluff ! A very good morning.
Just need a slight change regarding royalkings. As i wanted, you provided. What if i need vice versa. For example 2 way in royalkings whenever i put r i get 1, or whenever i put 1 i must get r. It shud work both ways mixed way. Hope u got it.


Bye & regards. Love n care.