Weekly eTip - Excel Text to Columns feature

February 12, 2013

Question: Can you help me create a macro in Excel to split text in a column so that I can use it to better analyze my large spreadsheet? I've been struggling for days trying to figure this out.

With Excel, there are a number of easy-to-use functions you can use without having to create macros. For example, you can split text into separate columns, especially if there are some consistencies in the text such as symbols or text, using the Data tab option > Text to Columns. If you select the Delimited file type, then you can identify the characters on which to separate the text. You also can select fixed with file types.

You can perform a variety of other functions with data tables such as grouping and filtering your data. In addition to these functions, you can create impressive pivot tables which can summarize large spreadsheets in seconds. Learn more about Excel features in:

  • ITS' Excel Basics Part II on Feb. 13 from 2 to 4 p.m. and
  • Excel Easy Pivots on Feb. 19 from 1 to 3 p.m.

Register from the Employee Self Service website and click on the Education - My Registrations link, or you can email csttrain@unmc.edu if you would like to attend.

There are a variety of self-study training courses on Excel at http://office.microsoft.com/training and you will learn about more resources in ITS training classes and drop in help sessions. The next drop in help session will be Feb. 19 from 3 to 4 p.m. after the Excel Pivot Table session.

Comments

Fill out the following and your comment will post once it has been approved.

Thank you, your comment will appear below once it has been approved.