I know there are threads on this, I just keep coming up short. Here goes:
If cell A2 has a word that and that word end in "cn", I need to return the word without "cn". If there is a word without "cn", I need to return the full value of the word.
Example 1: ATPCN returns ATP
Example 2: XYZ1 returns XYZ1
Example 3: ACND returns ACND
Hope my examples help. Any assistance is greatly appreciated. Many thanks!
Assuming your string is in A2, then try this...
Is this what you are trying to achieve?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Yes, that works great thanks! Last enhancement if possible. After each string, whether or not "CN" has been deleted, I need to add "Equity Ticker" fight after the original word. Is it possible to do in same line or do I need to add a new column and add that in the next column? Thanks again!
That's easily done by using htis modification of sktneer's formula:
Formula:
Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you! I had it on the wrong side of the ). Thanks for all your help!
OK!! If that's it, can you mark the thread a solved and preferably sau thanks to those who helpedby clickino the Add Reputation button at the foot of their post(s)?
Thanks for that!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks