0.008 btc To 1st Person To Help Me With Excel Solution Must Work

[campycoin]

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


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

[jnwood]

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

[campycoin]

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

[campycoin]

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

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.

[campycoin]

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

[jnwood]

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.

[campycoin]

Paid-

Thanks again

[Justin00]

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..

[SirChiko]

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

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..

That would actually be good idea

[Mikez]

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.

[Ejaculation]

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..

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

[Cryptopher]

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.

[jnwood]

Paid-

Thanks again

Received.  Thanks!

[Cryptocure]

...and do you know if I can close a thread or just lock it?

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

[techgeek]

Dammit!

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