How do I change the position of the columns in an Excel format?

  • Thread starter Thread starter pjbalvanz
  • Start date Start date
P

pjbalvanz

I exported the data in Schedule Plus to an Excel format. The columns are all
mixed up. I would like the Last Name and First Name to be together. Any
idea how to make that happen?
 
Insert a helper column to the right of the the first & last name columns and
enter the following formula:

=A1&", "&B1

Copy the formula down the column. Copy the entire column of formulas and
then click EDIT/PASTE SPECIAL, click the VALUES option button and click OK to
replace the formulas with their current result.

Delete columns A & B if you don't want the parsed names in the worksheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Numbers in a column won't add up 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Numbers showing Up Centered in Cell ? 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Column that needs separation 2
Date Formatting 2
Date columns are formatted incorrectly on export to excel 1

Back
Top