ANTI ..+ ACL = ANTICAL
ANTI ..+ ACR = ANTICAR
ANTI ..+ AFS = ANTIFAS
I want on those ACL generated by macro , macro to read at least 11111 rows
see file attached manually done results
ANTI ..+ ACL = ANTICAL
ANTI ..+ ACR = ANTICAR
ANTI ..+ AFS = ANTIFAS
I want on those ACL generated by macro , macro to read at least 11111 rows
see file attached manually done results
possible with 'concatenate' ??? see in cell E5
=CONCATENATE(A5,MID(C5,2,1),LEFT(C5,1),RIGHT(C5,1))
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
I want results of column C cells , E letter MINUS A letters , then ALPHA ARRANGE
Is it?
C1:
=MID(E1,LEN(E1)-1,1)&MID(E1,LEN(E1)-2,1)&RIGHT(E1,1)
Wow Jindos it works without even a macro , thank you
It does not ALPHA for all words see this it does ASG INSTEAD OF AGS for ANTISAG
ANTI ..+ ACL = ANTICAL
ANTI ..+ ACR = ANTICAR
ANTI ..+ AFS = ANTIFAS
ANTI ..+ AFT = ANTIFAT
ANTI ..+ ASG = ANTISAG
ANTI ..+ AGY = ANTIGAY
ANTI ..+ IAR = ANTIAIR
ANTI ..+ AJM = ANTIJAM
ANTI ..+ AMN = ANTIMAN
ANTI ..+ RAS = ANTIARS
You need to explain why extract AGS, from ANTISAG
@Jindon
Post #3 - "alpha arrange" = sorted alpabetically.
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.
are you expecting the 3 letters to be sorted alphabetically?
ASG becomes AGS
All you examples give the impression the rule is to swap first and second letters.
What would you expect from the letters ZED and ZDE
If only you had a newer excel version you could use
=A1&TEXTJOIN("",,SORT(MID(C1,SEQUENCE(LEN(C1)),1)))
Then vba
Please Login or Register to view this content.
googled and found this formula
=A1&CHAR(SMALL(CODE(MID(C1,{1,2,3},1)),1))&CHAR(SMALL(CODE(MID(C1,{1,2,3},2)),2))&CHAR(SMALL(CODE(MID(C1,{1,2,3},3)),3))
Re attaching file anyone to see if formula will , first three RED TEXT , manually plugged
Last edited by makinmomb; 02-17-2022 at 07:42 AM. Reason: attach file
Andy Pope if your formula works , plug in the attached to see if it pours results
those red cell example suggest an simple swap of first and second letter, not sorted. So I'm confused by what you want.
ANTICAL MINUS ANTI , BALANCE LETTERS IN ALPHA MODE for ANDY POPE , closer clarification , see expected results ACL ACR AFS AFT AGS NOT ASG
ANTI ..+ ACL = ANTICAL
ANTI ..+ ACR = ANTICAR
ANTI ..+ AFS = ANTIFAS
ANTI ..+ AFT = ANTIFAT
ANTI ..+ ASG = ANTISAG
ANTI ..+ AGY = ANTIGAY
ANTI ..+ IAR = ANTIAIR
ANTI ..+ AJM = ANTIJAM
ANTI ..+ AMN = ANTIMAN
ANTI ..+ RAS = ANTIARS
See workbook.
U are using column c for the formula where C were manually plugged results where the formula is required
Change the formula to reference E.
Your results do not match you description. Or I'm completely misunderstanding your requirement.
ANTISAG will create AGS and Not ASG. As G comes before S alphabetically
ANTIAIR will create AIR and Not IAR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks