Excel Forum
Similar Content
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Split Text into Multiple Cells in Excel
Tutorial: How to split text from one cell into multiple cells quickly and easily in Excel.  This in...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...

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

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.

Got a Question? Ask it Here in the Forum.