Excel Forum



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.