Excel Forum
Similar Content
Split Cells with Multiple Lines - Text-to-Columns using Carriage Return
Tutorial: How to split a cell by each line of data within it; this will put each line into its own ...
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...
5 Must Know Paste Special Tricks
Tutorial: The 5 best things you can do with the Paste Special command in Excel, with examples. Secti...

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.