Join 3,373 readers in helping fund MetaFilter (Hide)

2 posts tagged with excel by scarabic.
Displaying 1 through 2 of 2.

Related tags:
+ (192)
+ (88)
+ (68)
+ (51)
+ (47)
+ (45)
+ (45)
+ (35)
+ (30)
+ (30)
+ (25)
+ (24)
+ (22)
+ (22)
+ (21)
+ (20)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
Anonymous (4)
willnot (4)
FireStyle (4)
desjardins (4)
zardoz (4)
SirStan (3)
Jackie_Treehorn (3)
jujube (3)
goethean (3)
skypieces (3)
jefficator (3)
bluejayway (3)
mwhybark (3)
anastasiav (3)
Conrad Cornelius o... (3)
undercoverhuwaaah (3)
stupidsexyFlanders (3)
sdis (3)
foxinthesnow (3)
Mr. Justice (3)
ttyn (3)
corpse (3)
GilloD (3)
keep it tight (3)
apark (3)
Carialle (2)
bluefly (2)
demagogue (2)
bibbit (2)
Irontom (2)
Seeba (2)
Rad_Boy (2)
skryche (2)
thankyoumuchly (2)
synecdoche (2)
Lentrohamsanin (2)
digiFramph (2)
Jimbob (2)
rippersid (2)
furtive (2)
monocultured (2)
jestonb (2)
lea724 (2)
beammeup4 (2)
xedrik (2)
sockpim (2)
pwb503 (2)
nickerbocker (2)
ObscureReferenceMan (2)
crapmatic (2)
pantufla (2)
rorycberger (2)
prunes (2)
ParisParamus (2)
WCityMike (2)
dmd (2)
ewiar (2)
squorch (2)

Using Excel's FIND feature to find open parentheses.

I need to use Excel's FIND function to locate open-parentheses, but since parentheses are part of the syntax of the function itself, it's choking. How can I escape the character to make this work?
posted by scarabic on Aug 6, 2004 - 8 answers

Excel Hotlinking

Yo, skryche! How do I keep Excel from hotlinking URLs as I paste them into cells? I use spreadsheets to store, sort, and transform lots of URLs. But Excel seems to think that anything beginning with "http://" is something I want blue and underlined and hotlinked for easy clicking. It doesn't happen right away, only once I leave the cell does it become a hot link. I'd like Excel to just leave my text strings alone. I don't want to launch a browser window every time I click in a cell that contains a URL. And I'm tired of doing the right-click-remove-hyperlink thing every single time. Formatting the column as plain text before dropping in the URL *doesn't* work. As soon as you paste a URL into a cell, Excel wakes up, decides to "preserve the formatting" of your pasted text, and voila! A nice blue hot link. Is there a preference I can un-check for this?

Sorry if this is a stupid one. I can't find anything in the help documentation or via Google that solves my stupid problem.
posted by scarabic on May 28, 2004 - 8 answers

Page: 1