I have these on a and b
AADEFGL DLG
AADEGLS DLG
AADGHIL DLG
AADGLNO DLG
AADGLRU DLG
ABDEEGL DLG
ABDEEGL DLG
ACDEEGL DLG
ACDEGLO DLG
I need formula on C to minus DLG and vowels from A to give the remaining letter , thus answer of AADEFGL will be F on the c formula
Look at SUBSTITUTE function.
Adapt one of the many similar solutions you have been given in the past.
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.
May be try
C1Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you Shukla , for saving my day , I had this somewhere , could not find the file
Isn't it time you got organised? I use OneNote to keep all the tricks I learn. You could do something similar.Originally Posted by makinmomb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks