CT 94: I live my life a quarter mile at a time...

[dartsndeacs]

not sure there's ever been a more appropriate autocorrect

 

[freakadeac]

Quick random excel question for phan or anyone else. Imagine you have some cells with random blank space in them. What is the quickest way to correct the cells so you can run formulas on the cells? I do a random formula to correct the incorrectly formatted cells and then run formulas off the new set of data, but is there a quicker way to fix the incorrectly formatted cells? ('Format cells' doesn't work.)

 

[deacphan]

Quick random excel question for phan or anyone else. Imagine you have some cells with random blank space in them. What is the quickest way to correct the cells so you can run formulas on the cells? I do a random formula to correct the incorrectly formatted cells and then run formulas off the new set of data, but is there a quicker way to fix the incorrectly formatted cells? ('Format cells' doesn't work.)

like they have spaces in them? "trim" would work on that.

 

[deacphan]

not sure there's ever been a more appropriate autocorrect

wasnt an autocorrect. was a play on the "end this error" bush bumper stickers.

 

[DeacHoops]

like they have spaces in them? "trim" would work on that.

yeah, is this what you're meaning? if so, i tend to do a find/replace and replace a space with nothing

 

[deacphan]

probs better. looks like trim doesnt trim the space between numbers unless there are multiples.

 

[freakadeac]

yeah, is this what you're meaning? if so, i tend to do a find/replace and replace a space with nothing

This is perfect. My boss was looking for a way to correct the formatting without the trim formula. Sorry I wasn't more specific

 

[marquee moon]

there is that cut of the population that was too uncoordinated to play any sports growing up but then as adults they find running, bicycling, etc. and get super into it and fit

I played lots of sports growing up and was actually fairly good at street/roller hockey.

 

[RollTheQuad06]

Just got a ticket from work for the Wake game tonight. Part of me thinks this is punishment. Don't really want to go, but feel like I should.

 

[WakeBDer]

I'm leading a resume building class for high schoolers tonight. Does that seem a bit extreme?

 

[DeaconCav06]

I had a résumé in high school.

 

[Wakeforest22890]

I had a resume in high school too. Am I misremembering or did some colleges ask to attach one if you had one? I don't think it's overkill at all.

 

[dartsndeacs]

too many threads blowing up at once, can't get work done

 

[deacphan]

same palma

finally feeling better from the flu, and i actually have some interesting work to do. BUT I JUST CANT CONCENTRATE.

 

[WakeBDer]

I had a résumé in high school.

I had a resume in high school too. Am I misremembering or did some colleges ask to attach one if you had one? I don't think it's overkill at all.

Yea, I guess I did too. These are rising Juniors and rising Seniors.

 

[deacphan]

I had a résumé in high school.

I had a resume in high school too. Am I misremembering or did some colleges ask to attach one if you had one? I don't think it's overkill at all.

DOOOOOOOOOOOOOOOOOOOOORK

 

[DeacHawk]

I'm leading a resume building class for high schoolers tonight. Does that seem a bit extreme?

I had a résumé in high school.

I had a resume in high school too. Am I misremembering or did some colleges ask to attach one if you had one? I don't think it's overkill at all.

i knew what a resume was in high school :noidea:

 

[Bronson Pinchot]

I'm leading a resume building class for high schoolers tonight. Does that seem a bit extreme?

The kids there are gonna be so pissed at their parents.

 

[buckets]

I played lots of sports growing up and was actually fairly good at street/roller hockey.

ah, i didn't mean anyone in particular on the boards

 

[dartsndeacs]

What do you have to have done to claim being good at sports? Starting varsity? Making all star teams?