IF Statement with multiple or conditions

[aquad6]

Hi There!
I am trying to write a formula that allows me to place a dash before the last character in a cell text if it is an A,B,C etc. For example, if I have a sku that reads JH004A and I would like a formula that will populate another cell with JH004-A. IF it doesn't contain A,B,C etc. I want the other cell to read False. So far this formula =IF(AND(RIGHT(A2,1)="B"),LEFT(A2,LEN(A2)-1)&"-"&RIGHT(A2,1)) works but only if the end character is a "B", I can't figure out had to make it work if the end character is an A, or C. Any help would be greatly appreciated!! Thank you!

 

[Peter_SSs]

Some of my skus have two Alphabetical characters at the end while others have only one.

If they are the only possibilities then you could try this formula.

23 06 24.xlsm
	A	B
1	MO456CD	MO456-CD
2	AAA1B	AAA1-B
3	A3AA	A3-AA
4	12ab	12-ab
5	1A2B3C	1A2B3-C
Dash

Cell Formulas
Range	Formula
B1:B5	B1	=REPLACE(A1,LEN(A1)-ISERR(-MID(A1,LEN(A1)-1,1)),0,"-")

 

[Peter_SSs]

.. or for any number of alphabet characters (including zero) at the end

23 06 24.xlsm
	A	B
1	MO456CD	MO456-CD
2	AAA1B	AAA1-B
3	A3AAA	A3-AAA
4	AAAC123	AAAC123
5	12abc	12-abc
6	1A2B3CCCC	1A2B3-CCCC
Dash (2)

Cell Formulas
Range	Formula
B1:B6	B1	=LET(p,LEN(TEXTBEFORE(A1,SEQUENCE(10)-1,-1))+1,IF(p=LEN(A1),A1,REPLACE(A1,p+1,0,"-")))

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

On this occasion I have merged both threads.