Remove extra space in text using TRIM function
TRIM function are text/string function in excel. TRIM function is used to eliminate additional spaces from a text and it allows one space to remain between words. It can also be used to omit extra space which have appeared from data copied from other platforms which had irregular spacing.
https://excelhub.org/how-to-use-excel...