UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Re: Spreadsheet question :	by PeKaJe	2013-03-07 01:29:15
Assuming I understood the format correctly, with the text in A1, you should be able to use something like this for the text: =LEFT(A1;FIND("(";A1)-2) And something like this for the number: =MID(A1;FIND("(";A1)+1;FIND(")";A1)-FIND("(";A1)-1) This assumes that ( and ) aren't part of the text. Variable length, spaces, and hyphens shouldn't be a problem, and the number length may be anything.
[ Reply ]
I'd say that's right. use VALUE() to convert the	by bobmon	2013-03-07 01:57:39
Excel is pretty flexible with interpretation	by PeKaJe	2013-03-07 02:04:29
Some functions, such as AVERAGE(), STDEV(), etc.	by bobmon	2013-03-07 02:31:38
Ah, you're right	by PeKaJe	2013-03-07 02:40:22
Your solution worked great, but indeed	by Klaranth	2013-03-07 03:49:40

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)