| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate contents of cells whose contents resemble cell referem
cell A1 contains the value A
cell B1 contains the value 5 in cell C1, i want to concatenate the contents of cell A1 and cell B1 so that the answer would be A5 because the values resemble cell references, i'm having trouble. any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate contents of cells whose contents resemble cell referem
hi
try this.. =A1&B1 Regards FSt1 "cathyh" wrote: cell A1 contains the value A cell B1 contains the value 5 in cell C1, i want to concatenate the contents of cell A1 and cell B1 so that the answer would be A5 because the values resemble cell references, i'm having trouble. any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate contents of cells whose contents resemble cell referem
Try this:
=IF(COUNTA(A1:B1)=2,A1&B1,"") -- Biff Microsoft Excel MVP "cathyh" wrote in message ... cell A1 contains the value A cell B1 contains the value 5 in cell C1, i want to concatenate the contents of cell A1 and cell B1 so that the answer would be A5 because the values resemble cell references, i'm having trouble. any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate contents of cells whose contents resemble cell referem
because the values resemble cell references, i'm having trouble.
I'm not sure what kind of trouble you're having. If you're looking to retrieve the contents of the resulting cell ref in the concat string, then In C1: =INDIRECT(A1&B1) will do this -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "cathyh" wrote: cell A1 contains the value A cell B1 contains the value 5 in cell C1, i want to concatenate the contents of cell A1 and cell B1 so that the answer would be A5 because the values resemble cell references, i'm having trouble. any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula: copy/concatenate cell contents matching condition | Excel Discussion (Misc queries) | |||
| Concatenate cells, replacing blanks with cell contents from other rows | Excel Worksheet Functions | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
