Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting data that has different column headings
I am working on two spreadsheets. The first one is our main database, and I
want to insert data from the second spreadsheet. My problems is that the first spreadsheet has both the first name and surname in one cell under "contact name", whereas the second spreadsheet as the first names and surnames split between separate columns. Is there a way to combine the two columns to put the first names and surnames on the second spread sheet in one column? There are around 590 rows in the second spreadsheet (1,000s) in the first, so I don't really want to enter the names manually! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Headings from Column Data | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |