All articles filed in June 18, 2011

Excel String Tips – Part 3: TRIM and CLEAN functions When using data from the internet, either copied from a website or contained within a downloaded file, string data can be “dirty”. This could be unprintable characters or white space at either the front or end of the string. To remove excess space at the…