Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns

3,437 views · Published 14 October 2009 · 5:37 · Indexed 20 October 2026

Channel: excelisfun · 2009 · Science & Technology

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT407-414.xls

Web Site Copied Data Has Extra Characters? Use CLEAN function. Use the TRIM function. Use Text To Columns. Also, see how to use the IF and LEN functions to put a blank in the cell numbers with 1 or fewer characters, 1 for numbers that have 2 characters and 2 for numbers that 3 or more characters.

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008