G
Guest
How can I trim the last space from text but leave the other spaces intact
ie:- Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)
Sir Edward Landseer (FR) Sir Edward Landseer (FR)
I've tried =SUBSTITUTE(A1," ","") but this trims all the spaces out.
Any help will be welcomed.
ie:- Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)
Sir Edward Landseer (FR) Sir Edward Landseer (FR)
I've tried =SUBSTITUTE(A1," ","") but this trims all the spaces out.
Any help will be welcomed.