If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ROWS WRaP AROUND
Trying to import a comma delimited file, which I have done several times. This time the file has 2 rows for each name, address, etc. Excel imports as 2 rows, but I need all the names in one column. How can I put 2nd row in import file into one long row in excel
|
#2
|
|||
|
|||
ROWS WRaP AROUND
Jess,
If I read it right your imported file ends up with something like this in the top two rows: A B C D E 1 Feet per Tom 432 Elm St Account 2 Mile Invoice Hanks Anytown, USA Number and you want 1A to say Feet per Mile (in this example). Try this: Insert a blank row below the last row of data you want to combine. In the first column of the new row (A3) enter the worksheet function below =CONCATENATE(A1," ",A2) The concatenate function strings together the values in the cells. The " " is so a space goes in between the words. If you leave out that argument, you get 'TomHanks' instead of 'Tom Hanks'. Then copy the formula to the other columns. The Drag Handle works great for copying into long headers. Play with it. Put "Jess" in and see what happens. You can always undo. Then you can copy the concatenated cells and do a Paste Special - Values to get the full name or address in single cells. If you get lost use the F1 help for worksheet functions. Hope it helps. Good Luck! |
Thread Tools | |
Display Modes | |
|
|