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...


[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]

RSCAT TR Let The Sun Shine In​

[/td][td]

Let The Sun Shine In​

[/td][/tr]
[tr][td]

2​

[/td][td]

RSC GHT Night Runner​

[/td][td]

Night Runner​

[/td][/tr]
[tr][td]

3​

[/td][td]

RD FGH Midnight Mountain​

[/td][td]

Midnight Mountain​

[/td][/tr]
[/table]

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.