| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the position of the columns in an Excel format?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the position of the columns in an Excel format?
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. -- Kevin Backmann "pjbalvanz" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text boxes Excel 2003 change position in print preview | Charts and Charting in Excel | |||
| change horizontal header position in excel | Excel Discussion (Misc queries) | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
| Both columns change when I format only one column (A) | New Users to Excel | |||
| How can I change the position/format for all data labels in a ser. | Charts and Charting in Excel | |||
Hybrid Mode
