Excel: first name in one column, last name in another column. How do I get them in the same column?
598696
In Cell C1, insert "=A1 & " " & B1", assuming first name is in A and last name is in B.\n\nDrag the fill handle of C1 to fill up the other cells.\n\nCopy the Column C and right click. Select "Paste Special", select "Values" only. Now you can delete Columns A and B if you want to.
569995
Are you trying to get rid of the blanks?\n\nOne way is just to sort the column--that will pull all the blanks to the top or bottom, where they are easy to delete.\n\nIf you need to keep the order that values are in, try this:\n\n1. Select the entire column.\n2. On the edit menu, choose "Go to..." then click "Special..."\n3. In the box that comes up, choose "Blanks" and hit OK.\n\nYou should now be back in the sheet, with all the blank cells selected.  Right click, choose "Delete...", then choose "Shift cells up" and hit OK.\n\nThis is for excel 2002, it might be a little different in other versions.
792191
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).\n\nHowever, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.
682671
Limewire won't do that.\n\nIf you have Excel you can use the RND function to randomly select a name from a list.
296667
Vlookup isn't that hard once you know how it works.\n\nLet's see if I can show you here...\n\nYou have 4 columns...\n\n.. A.. B.. C.. D\n1.. 1.. =vlookup(A1,C1:D4,2).. 1.. One\n2.. 2.. =vlookup(A2,C1:D4,2).. 2.. Two\n3.. 3.. =vlookup(A3,C1:D4,2).. 3.. Three\n4.. 4.. =vlookup(A4,C1:D4,2).. 4.. Four\n\nThis will render the output...\n\n...A..B.....C...D\n1..1..One...1...One\n2..2..Two...2...Two\n3..3..Three.3...Three\n4..4..Four..4...Four\n\nIn vlookup, the first variable (A1) says "Here is the value I want you to look up in the table"\n\nThe second value, (C1:D4) says "This is where the table is"\n\nThe third value, (2) says "When you find a match in the first column, use the output from the second column"\n\nSo, in the first line (=vlookup(A1,C1:D4,2))\n\nIt says Look up the value in A1 (1) in table C1-D4 and display what you find in the second column.\n\nSince the value of A1 is "1", it finds "1" in C1 and displays whatever is in the second column, which is "One".\n\nSimple huh?  You can find more information here...\n\nhttp://office.microsoft.com/en-us/assistance/HP052093351033.aspx
1156460
You can select the column you want and copy it. Then go to the target (where you want to make it into rows) and select Edit -> Paste Special from the menu bar. In there, make sure you mark the box that says 'Transpose'. Voila!
190763
GETPIVOTDATA does get in the way...\n\nEither type the cell reference directly, or select another cell outside the table then click and drag it into the pivot table to the cell you want to refer to.  No other way round it I'm afraid!
999697
It sounds like you want to use VLOOKUP
860449
Make a table with two columns.
317497
This may be overly symplistic, but if it were me, I'd open up both files at the same time and just link from one file to the other as if I were linking between worksheets.  That way excel creates the full path for you.  You could do that for one cell, then do a search and replace for all of the others.
587883
Select all the data that belongs together first. \nIn my version, you then go to the menu: 'DATA' - 'SORT' \nYou can choose the row to sort, or in the tab 'Options' you can choose to sort columns.\n\nExperiment on a separate sheet so you can see how it works.
1086777
This is not a simple question to easily be answered.  First, the 'data' must be established in Excel.  Obtain the different fields of information and place each into it's own column.  Sep-10, Chicago, GreenBay.  Place the data beginning down a ways like row 15, and column D.  Label each column with a heading and keep the label simple: Begin with a letter, no more than 8 characters, no blanks, no spaces, meaningful to content, and not a reserved word (Excel command like SUM).  Then highlight the entire data range you placed and choose the INSERT-NAME-DEFINE and type database.  Then you can Go to the Heading line and highlight that line and copy to row 2 immediately above and paste it and also below the bottom line and leave 10-15 empty lines and paste the heading line again.  The top area should be INSERT-NAME-DEFINE and type Criteria.  The bottom area should be INSERT-NAME-DEFINE and type Extract.  When you define the Criteria you should include one blank line immediately below that heading line where you can place criteria that you would like to extract to the extract area from your 'Database".  The Extract area is just the data on the copied header line.  You place information like "Giants" under the FIRSTTEAM column and then on the Excel menu you select DATA-FILTER-ADVANCE FILTER-COPY TO ANOTHER LOCATION - UNIQUE RECORDS ONLY - OK and all the 'Giants' information will be copied to the extract area.  You can UNDO a selection by DATA-FILTER-SHOW ALL.  \n\nThis is the Database feature within Excel and is simple to setup and very useful to extract many types of data.
55468
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.
65173
Paste this formula in the third cloumn\n\n=VLOOKUP(A1,B1:B4,1,0)\n\nAll the matching cells will get their values printed whereas the unmatched cells will contain #NA
840236
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
672487
Yes, VLookup is what you need\nPaste this function in B column in sheet Y\n=vlookup($A1; X!$A:$D; column(); false)\nwithout these spaces..and fill down and right\n\nXLMan
829503
I accept the challenge for the fun of it.\n\n...will get back to you.\n\n\nOK.  in cell G5, based on what you describe, the formula is "=VLOOKUP(+E5,$B$2:$C$5,2)"  Note the dollar signs in the formula referring to cells B2 and C5.  This will allow you to copy cell G5 into G6, G7, G8, and so on if you have more values in column E.\n\n\nNOTE: In column B2 to B5 are the numbers 0, 32, 63, and 94 respectively.  In column C2 to C5 are the words Freshman, Sophomore, Junior, and Senior respectively.