Need to trim various prefixed that are in ALL CAPS off of text in a column

[funguy]

We have song titles in a column that have ALL CAPS prefixes that we use internally to identify the writer/origin of the song. For example:

RSCAT TR Let The Sun Shine In
RSC GHT Night Runner
RD FGH Midnight Mountain


I need to trim the ALL CAPS gibberish off of the front of the titles , leaving simple "Let The Sun Shine In" etc

I have this formula (below) for trimming around a common cluster of characters. Could I play off of this somehow and trim ALL CAPS characters from the Beginning? Any help is much appreciated

=TRIM(LEFT(N2,FIND(" -by- ",N2)-2))

 

[Marcelo Branco]

Maybe...

	A​	B​
1​	RSCAT TR Let The Sun Shine In​	Let The Sun Shine In​
2​	RSC GHT Night Runner​	Night Runner​
3​	RD FGH Midnight Mountain​	Midnight Mountain​

Array Formula in B1 copied down
=MID(A1,MIN(IFERROR(FIND(CHAR(ROW(INDIRECT("97:122"))),A1),""))-1,LEN(A1))

confirmed with Ctrl+Shift+Enter, not just Enter

M.

 

[funguy]

Oh awesome , thank you much. But what do you mean by "confirmed with Ctrl+Shift+Enter, not just Enter" ?

 

[Marcelo Branco]

Oh awesome , thank you much. But what do you mean by "confirmed with Ctrl+Shift+Enter, not just Enter" ?

You need to confirm the formula with Ctrl+Shift+Enter simultaneously because it's an array formula.
(keep pressed both Ctrl and Shift keys and hit Enter)

Take a look at
Array Formulas

M.

 

[funguy]

It worked ! amazing. thank you Marcelo!

 

[Marcelo Branco]

It worked ! amazing. thank you Marcelo!

You are welcome and thanks for the feedback.

M.