Ask Your Question

stevenolan's profile - activity

2014-06-20 21:05:02 +0200 received badge  Famous Question (source)
2014-04-14 21:08:23 +0200 received badge  Notable Question (source)
2014-04-01 22:36:57 +0200 answered a question Problem using offset with concat to current cell.

Thanks guys. Turns out to be a pretty stupid question. It was late at night. I just wanted to concatenate the adjacent two cells to the left of my current cell to my current cell. Example:

J10 = "abc" K10 = "def" J20 = "ghi" K20 = "jkl"

originally I had L10 = concatenate(J10,K10) : Result = "abcdef" If I cut and paste L10 to L20 then L20 became concatenate(J10,K10) : Result = "abcdef" I did not want this I wanted L20 to become concatenate(J20,K20) : Result = "ghijkl"

Solution was L10 = concatenate(offset(L10,0,-2),offset(L10,0,-1))

If I now cut and paste L10 to L20 then L20 becomes concatenate(offset(L20,0,-2),offset(L20,0,-1)) : Result = "ghijkl"

So, problem solved.

Again, thank you all.

2014-04-01 22:17:30 +0200 received badge  Popular Question (source)
2014-04-01 00:19:06 +0200 asked a question Problem using offset with concat to current cell.

I want to concatenate the contents of two cells immediately to the left of my current cell, and place the result in my current cell, by using the offset functions. Is this possible? I cannot figure it out. I tried using address(row(),column()) to reference the current cell and offsetting from that value, but just get error 504.

Formula goes into cell L10. concatenate(offset(L10,0,-2),offset(L10,0,-1)) works fine, but I need to remove direct reference to current cell, i.e. L10.

tried replacing L10 with address(row(),column()) .. does not work. also tried cell("address") .. does not work either. Probably to do with result format but I do not know solution. 20 years ago I would have pursued like a dog with a bone, but age has slowed me down and I cannot endure long nights anymore. Any help joyfully received.