Bitcoin Forum

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
http://image.bayimg.com/3ce5df7149ee8e5815b54d7b56c14e895d8c9c63.jpg

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

Put a $ in front of either the letter or number in a cell name to make it stay constant when replicating.  Perhaps look at this explanation:  http://blogs.office.com/2011/08/17/making-sense-of-dollar-signs-in-excel/

So make your first 4 rows this instead:
c2&d$2
c3&d$2
c4&d$2
c5&d$2

and they should copy just fine after that making your 5th c6&d$2

I'm going to go try it.  If it works, give me your address

jnwood wins  THANKS SO MUCH 

A FUCKING $ SIGN  Wow!

I do like that I can just send some btc and PayPal or any of those other scams don't get none.

Just need your address and do you know if I can close a thread or just lock it?

Cool, glad it worked.

12qy2a4p5QJAE3Q8cNCTtk6xXXYnQ49YWD

I'm not familiar enough with Bitcointalk to know if you can close this thread or not or how to do it.

Paid-

Thanks again

good job guys.
I wish the forums had a bounty section. Yeah yeah I know their is services and project dev, but still.. bounty section would be nice.
perhaps i'll suggest it in the meta section..

Ah seems i'm late althought i'm glad you've solved it.

That would actually be good idea :)

While I'm glad OP found a solution to his problem in excel, I cannot help but notice his ignorance when he chose to post in the Bitcoin Discussion forum. But I do understand his frustration, we've all had those 'I'm stupid' moments.

PS: Marketplace - Services, that would have been a better place to post.

We should. Did you suggest already or should I myself?

Wish I had seen this earlier. The solution provided is something called absolute cell referencing just so you are aware in future :)

I like threads like these. Not enough of them for my liking hehe.

Received.  Thanks!

To answer this question, there should be a "lock topic" option in the bottom left-hand corner (if you scroll all the way down).

Dammit!

I didnt see this sooner.. you got anything else you need help with? lol.