| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i add 2 columns to make the answer apper on the 3rd col
If you want to combine text cells such as first & last name, if first name is
in B4 & last name is in C4, place your cursor in the cell where you want combined info & use the function =B4&" "&C4 (if you want last name first then a comma then first name, use =C4&", "&B4. You can combine numerous cells this way, ie. =B4&" "&C4&" "&D4" " &E4. use the " " marks to place a space, dash, or any other character between combined cells Hope this helps "darkwood" wrote: I'm not sure if you are providing enough information for an accurate answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag down column C. -- darkwood ------------------------------------------------------------------------ darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948 View this thread: http://www.excelforum.com/showthread...hreadid=506776 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format macro | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
