Hi, I have a large matrix of data with column names like this:
I would like to short these to
Unfortunately the second part (123A) is 4 or 5 characters so I can't cut it by length?
Is there a way to use gsub to sub everything from the second - for ""? Or another solution?