Greetings!
I want to return name after 30 caracters.
e.g. "2356_26_10_2012_hgkl_DFGR_BNG_AssemRoller_Linear-JKO"
once the final words are variables this is the result i want to obtain
"AssemRoller_Linear-JKO"
thanks
Greetings!
I want to return name after 30 caracters.
e.g. "2356_26_10_2012_hgkl_DFGR_BNG_AssemRoller_Linear-JKO"
once the final words are variables this is the result i want to obtain
"AssemRoller_Linear-JKO"
thanks
If the text is in A1:
=RIGHT(A1,LEN(A1)-30)
This will work as long as there are always 30 characters to remove.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
ain't working, maybe because of use of excell 2010?
Has worked.
It was because of use of formula in portuguese.
When i made the relation worked!
Thanks
Yes, you need ; where I use ,. Please mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks