CRUNCHING TEXT IN EXCEL
How to Manage More Than Numbers
Often data is not in the format we want, such as when a column contains text you need separated into two columns. Instead of cutting and pasting several times or retyping to divide words into different columns, use this quick feature:
• Highlight the data to be separated.
• On the Data menu, choose Text into Columns and start the Wizard.
• Step 1, check delimited, click Next.
• Step 2, check the Space option in the Delimiters section. Click Next.
• Step 3, you can format and place your data or just click Finish.
Once you have converted text to columns, you might notice some extra spaces around the text in a cell. To easily remove these spaces, use the TRIM function.
• Choose the cell with the extra spacing, let’s say its cell A1.
• Select a blank cell to paste your new, “trimmed” text into.
• Type =TRIM(A1). The cell will now have the text from A1, without space. Use these great tips to save time as you clean up your data!
USE OUR MS OFFICE FOUR AND EIGHT PACKS AND SAVE!
Sign up now for outstanding classes at great prices!
Share these passes with your colleagues for maximum flexibility!
HELP MY WEBMASTER JUST QUIT!
If you change your website's content frequently, use our special software to make the changes without having any web skills. Call us to learn more.