Removing spaces or special character from text values is very crucial task in excel reporting projects. Because, if text value contains spaces or white character or any special then it results into data mismatch for using functions like Vlookup, Index-Match, sumif and so on.
However, to minimize chances of data mismatch in various such functions which works on text input is to trim text values for spaces or special character which is not required in data. Excel is enriched with few functions which will help us to remove spaces or unwanted special character in text values.
However, to minimize chances of data mismatch in various such functions which works on text input is to trim text values for spaces or special character which is not required in data. Excel is enriched with few functions which will help us to remove spaces or unwanted special character in text values.
