In certain condition we copy text material from internet or any other web resources and then paste them in our excel sheet ,text does not appear in proper way. so in that case TRIM function can be very useful.After using TRIM function data will appear in very nice manner.
In the second part of the video you concatenate function exhaustive explanation is provided, how one can use this function to combine the text provided in two different cell can be combined in single cell in excel.
00:27 how to download material from google
01:54 use of trim function
04:56 concatenate function without space
05:49 concatenate function space
06:47 concatenate function with &
08:17 concatenate function with vs.
09:42 concatenate function with –