I would need to split only specific strings to numbers and then maximize these numbers from the specific strings in Google sheets?
Example of my google sheet spreadsheet cells below
1
AAA C1
BBB C4
AAA C7
A1: "AAA C1"
B1: "BBB C4"
C1: "AAA C7"
I would need to maximize the highest numbers after the letter "C" fr…