Forum Discussion
Excel Formulas and Copy Down Rows
I just started Windows 2016. I typed in a formula to concatenate tow cells. However, the formula shows up in the cell instead of the results. I know if you click in the cell and hit F9 the results...
Barbara, Sorry I'm not your savior. Having same problems myself. Didn't know about the F9 trick. I stumbled across (1. highlight cell. 2. click in formula bar to right of formula. 3. hit enter. ???? ) Go figure. I have been doing this on nine cells every day. You've helped me immensely though. Turns out the F9 trick on first problem cell automatically works on any adjacent cells using the same: (IF: A>0 ).
I'm waiting on the same savior though. It's a REAL PAIN.