Separate Fund Ticker from Fund Name that has no delimiter

[sericson]

Hello! how Can I separate into a new column the Fund Ticker from the Fund Name (example below, last 5 uppercase letters) there is no delimiter to use the text to columns. I thought of using the RegEx tool but I am not sure of the formula or if this is correct. 

Janus Henderson Glb Tech and Innovt I JATIX

Vanguard Real Estate Index Admiral VGSLX

Vanguard Health Care Adm VGHAX

[binuacs · Accepted solution]

@sericson One way of doing this

[Luke_C]

Hi @sericson 

Here's a regex formula to extract based on capital letters:

REGEX_Replace([Fund], '.*\b(\u)', '$1')

[Dina]

Just another way.

[sericson]

thank you! this worked perfectly