| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenating two text strings, formula is right, cell output is w
I have a simple formula and my cells are all formatted as general, but when I
copy the formula down several cells, the values do not chnage, they stay the same as the first cell. When clicking on the function helper (Fx), the info returned is correct, but it shows up in the cell incorrectly. For example: formula =CONCATENATE(A1,".",B1) Joe (A1), Smith (B1), results in Joe.Smith But when I copy the formula down, i still get Joe.Smith returned, when it should be Sue.Jones formula =CONCATENATE(A2,".",B2) Sue (A2), Jones (B2), results in Joe.Smith However, when I click on the "Fx" by the formula bar, the dialog that pops up shows the results of the formula accurately, i.e. "Sue.Jones" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for concatenating text with results from calculation | Excel Discussion (Misc queries) | |||
| Splitting Text strings in one cell | Excel Discussion (Misc queries) | |||
| How do I start new line when concatenating text strings in excel? | Excel Discussion (Misc queries) | |||
| add text to end of formula output | Excel Discussion (Misc queries) | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
