I'm totally am an imbecile , I have accepted that fact.
I am trying to do something fairly simple an have had an excel headache all day.
I have a spread sheet like shown below
![](https://ip.bitcointalk.org/?u=http%3A%2F%2Fimage.bayimg.com%2F3ce5df7149ee8e5815b54d7b56c14e895d8c9c63.jpg&t=665&c=bCtdticqXv6ahQ)
The problem is that the HTML code in column D is way too long and if I drag it the length (2500 rows) it causes the file to go up past 50mb and causes excel crashes and the max the file can be is 15mb.
So, I simply need a formula for column F to bring over the C column and have column D follow it
so F2 would show: cool car <code></code>
That is easy for cell F2 by using =(c2&d2) but now I need to populate F all the way to 2500 rows but I cannot drag the D html
So why can't I say (c2:c2500&d2)?
Or when I drag, it always changes the d2 so how do I keep it constant
I also tried filling in the first four formulas
c2&d2
c3&d2
c4&d2
c5&d2
and dragging but again, the next one in sequence becomes c6:d3
So Somebody know how?
0.008 btc to the person that gives me an answer in an hour... 7:22 PST I need to be done by 8:22pm