Questions & Answers for: concatenating Computers & Internet

excell vlookup formula I'm try to use vlookup formula and doesn't found the value. The formula is as follow: =VLOOKUP(CONCATENATE(D3,L3),'[bills up to 022908.xls]Sheet1'!$G$3:$J$50000,4,0) D3= file ...

Echo PHP What is the difference between PHP echo and print? Print outputs a single string, echo can output multiple strings. (It's in the help file.) Echo is marginally faster than print, and print ...

excel formula for example i am doing a report using excel. I have no. 5 in sheet1 cell a2 and nos. 2,45,6,76,88 in b2,if i click sheet 2 the output must be sheet 2 cell a2 b2 5 52 5 545 5 56 5 576 5 ...

Need a range answer in excel I'm calculating a range (15-25%) of a variable in another excel cell and want this new cell to answer with the range (.15*b27 to .25*b27), rather than a single answer. Is ...

merge two records in ms works 2000 I want to be able to merge two or more records in Microsoft works 2000 I started with an ascii II file of addresses. I imported that list into an Excell spreadsheet.

Dear sir, I have a data in different columns like a b c d e f g h i j k l m n o p q and I want to merge data in (of a b c d in a) of k l m n o in g pls help me to sort this. in Column A put this ...

sorting a single column with both first name and last name I am trying to sort a field containing both first name and last name, the trick is i want to sort it by last name? how do i do it because so ...

all words in column A must be equal to column B plus the word on column H row 2...what is the formula? example: a2(dentist) h2(chico) on b2 must be "dentist chico" You could use Concatenate ...

Hyperlink other document in excel button i have 100 pdf document with different names. and i want it to open these documents through excel. for example. to open a document i type its name "BOOK1" in a

what is the "&" symbol for in excel 2010? The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from ...