So just got told by IT that my new iPhone has arrived and is being configured. I should be excited yet am filled with ambivalence. Please tell me how silly I am being and that the iPhone 4 is magical and worth my $400?!
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
I want an iPhone 4 very badly.
javachik, MAGICAL SPARKLEPONIES
I am forgoing mani/pedis and meals out to budget for the magicphonesparklyness.
Even with a Sansa clip, I'd have no way to get the files from the Internet to the device since Overdrive for Mac only recognizes mp3s.
What's the formula that I need to search a row to find out if any value contains a certain character? Not is equal to, but contains? I need to scan a range for "|", and I can't work out the simplest way. Everything I can think of is unduly convoluted.
I think writing a quick macro using the Find method will work, but maybe that counts as convoluted? [link]
Yeah, that counts as convoluted. I'll just go back to the SQL or something. I hate data.
Thanks, though.
The problem is I need to search a range (most of a row), not a cell. That's what's tripping me up. I guess I could concatenate those cells first--it's just dragging the formulas, in the end.
Thanks.
oh, I see. how many cells are in the row, roughly?