This is important if we wish to use the result of the function within other functions or formulas. The picture of Step 1 is below. To join multiple cell values with a comma we can use a formula based on the SUBSTITUTE and TRIM functions.
You can also use the LEFT function in VBA.
Check the video below to see How to use Excel LEFT function with some examples. To join multiple cell values with a comma we can use a formula based on the SUBSTITUTE and TRIM functions. In this example the left function is used to extract the area code from a phone n. Similar to Left function in excel Right function is also a text function which is used to give the number of characters from the end from the string which is from right to left for example if we use this function as RIGHT ANAND2 this will give us ND as the result from the example we can see that this function takes two arguments.