How do I copy a calculated cell into a cell where the source data comes from?
For example, in Cell D3 I have a formula =CONCATENATE("4601-",B3)which gets me "4601-1234".
Now I want to replace what's in B3 with what is in D3 without getting the REF#("1234" turns into "4601-1234"). Basically I'm replacing stuff.
For example, in Cell D3 I have a formula =CONCATENATE("4601-",B3)which gets me "4601-1234".
Now I want to replace what's in B3 with what is in D3 without getting the REF#("1234" turns into "4601-1234"). Basically I'm replacing stuff.