Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining first and last names into one column
Using excel 2003 Ihave two columns one with first name and one with last
name. In a third column I used the formula and got Lastname, first name, however I cannot delete the first two columns and retain the combined column. What have I done wrong? Help please. Virginia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining first and last names into one column
You'll need to select the column of formulas
Then...From the Excel Main Menu: <edit<copy <edit<paste special ....Check: Values ....Click: [OK] Then you can delete the original columns Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Virginia" wrote in message ... Using excel 2003 Ihave two columns one with first name and one with last name. In a third column I used the formula and got Lastname, first name, however I cannot delete the first two columns and retain the combined column. What have I done wrong? Help please. Virginia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Combining first and last names | Setting up and Configuration of Excel | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions |