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

3,436 views · Published 14 October 2009 · 5:37 · Indexed 23 September 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,557 views · 23 May 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,669 views · 4 August 2008

• 4:50 YTL Excel #123: Array Formula To Count E-mails

  excelisfun

  2,540 views · 11 September 2008

• 0:09 Kid Empties Bottle - Funny Waterfall

  excelisfun

  874 views · 6 August 2009

• 10:35 Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!

  excelisfun

  4,827 views · 15 September 2009

• 39:25 Excel 2010 Business Math 22: Adding & Subtracting Fractions Lest Common Denominator LCM Function

  excelisfun

  4,359 views · 9 October 2011

• 13:56 Excel 2010 Business Math 34: Begin Amount = (Amount of Change)/(Rate of Change)

  excelisfun

  2,623 views · 20 October 2011

• 2:43 Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets

  excelisfun

  4,720 views · 19 July 2012