• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Why am I getting the same value all the way down a column?

W

Weldon

New Member
I have been using the formula below for months with no problems; showing this formula to coworker, on a different computer, it worked for cell A4 only but returned the result from cell A4 in every cell below all the way down the column.


="A"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A4,"@ ",""),"-",""),9))


E.g. Cell "A4" would return properly A123456789, but cell "A5" returns the same A123456789 in "A4" even though the reference cell changes in the formula as I go down the column
 
First check the calculation mode in

Formula | Calculation | Calculation Options


Select "Automatic" option and see if it gets you desired results.
 
You must log in or register to reply here.
Back
Top