Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeating a formula in text
I'm concatenating two columns in an excel data file. The formula works, but
won't replicate in the column to subsequent rows, all it will do is copy. I'm tearing my hair out - I've done it before but all of the sudden it won't work. Can you help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeating a formula in text
1) What happens if you hit [F9] ?
If this recalculates the correct results - then your Calculation option is set to "Manual". 2) Did you, by mistake, fix the References of the concatenated cells with $ [like: $A$1] ? Micky "Lyn" wrote: I'm concatenating two columns in an excel data file. The formula works, but won't replicate in the column to subsequent rows, all it will do is copy. I'm tearing my hair out - I've done it before but all of the sudden it won't work. Can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating text | Excel Discussion (Misc queries) | |||
How do I set repeating text for a specific cell. | Excel Worksheet Functions | |||
searching for repeating text | Excel Worksheet Functions | |||
Text repeating on multiple worksheets | Excel Discussion (Misc queries) | |||
Repeating text in a text box within Excel. | Excel Discussion (Misc queries) |