When you import data from other programs it often comes
with additional spaces - at the beginning, at the end or even between words. Luckily
for us TRIM function will
remove the excess spaces from text, except for single spaces between words.
How to use the TRIM function
Example of using the TRIM function
The image below shows using TRIM function in column B and the result of using the TRIM function
in column C.
No comments:
Post a Comment