I know this is probably simple but I cannot find a way to derive a cell reference. For example, I want to retrieve ABC from cell A5.
I can develop "A" and I can devlop "5". I can paste them together to get "A5" but I cannot find a way to use the derived "A5" to retrieve ABC from cell A5.
Any ideas?
I can develop "A" and I can devlop "5". I can paste them together to get "A5" but I cannot find a way to use the derived "A5" to retrieve ABC from cell A5.
Any ideas?