+ Reply to Thread
Results 1 to 41 of 41

Longest Formula Ever

Hybrid View

astole Longest Formula Ever 08-01-2013, 04:57 AM
Mordred Re: Longest Formula Ever 08-01-2013, 11:11 PM
FDibbins Re: Longest Formula Ever 08-02-2013, 12:00 AM
Pepe Le Mokko Re: Longest Formula Ever 08-02-2013, 05:33 AM
JapanDave Re: Longest Formula Ever 08-04-2013, 03:51 AM
Tony Valko Re: Longest Formula Ever 08-04-2013, 09:28 PM
FDibbins Re: Longest Formula Ever 08-05-2013, 12:10 AM
cytop Re: Longest Formula Ever 08-31-2013, 09:26 AM
Tony Valko Re: Longest Formula Ever 08-31-2013, 10:25 AM
FDibbins Re: Longest Formula Ever 08-31-2013, 10:43 AM
JapanDave Re: Longest Formula Ever 09-01-2013, 04:09 AM
Tony Valko Re: Longest Formula Ever 09-01-2013, 10:51 AM
JapanDave Re: Longest Formula Ever 09-01-2013, 10:27 PM
lesoies Re: Longest Formula Ever 09-02-2013, 05:38 AM
romperstomper Re: Longest Formula Ever 09-02-2013, 06:27 AM
My335iTT Re: Longest Formula Ever 09-09-2013, 11:35 PM
lesoies Re: Longest Formula Ever 09-02-2013, 06:40 AM
Tony Valko Re: Longest Formula Ever 09-02-2013, 09:15 AM
daffodil11 Re: Longest Formula Ever 09-03-2013, 04:03 PM
romperstomper Re: Longest Formula Ever 09-04-2013, 03:35 AM
daddylonglegs Re: Longest Formula Ever 09-04-2013, 09:12 AM
daffodil11 Re: Longest Formula Ever 09-04-2013, 04:44 PM
daffodil11 Re: Longest Formula Ever 09-10-2013, 06:06 PM
Tony Valko Re: Longest Formula Ever 09-10-2013, 08:13 PM
:) Sixthsense :) Re: Longest Formula Ever 09-11-2013, 12:12 AM
Tony Valko Re: Longest Formula Ever 09-11-2013, 10:51 AM
shg Re: Longest Formula Ever 09-10-2013, 06:19 PM
daffodil11 Re: Longest Formula Ever 09-10-2013, 06:22 PM
Grimace Re: Longest Formula Ever 09-26-2013, 09:35 PM
Tony Valko Re: Longest Formula Ever 09-28-2013, 03:32 PM
RGrunden Re: Longest Formula Ever 10-18-2013, 01:07 AM
Jacc Re: Longest Formula Ever 10-29-2013, 04:10 AM
Jacc Re: Longest Formula Ever 11-20-2013, 05:31 PM
Tony Valko Re: Longest Formula Ever 06-21-2014, 08:04 PM
FDibbins Re: Longest Formula Ever 06-21-2014, 08:16 PM
TMS Re: Longest Formula Ever 07-26-2014, 04:29 AM
Tony Valko Re: Longest Formula Ever 07-26-2014, 09:26 AM
FDibbins Re: Longest Formula Ever 02-19-2015, 09:09 PM
Butcher1 Re: Longest Formula Ever 02-26-2015, 10:43 AM
Speshul Re: Longest Formula Ever 02-26-2015, 04:31 PM
Tony Valko Re: Longest Formula Ever 02-17-2016, 06:45 PM
  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Longest Formula Ever

    So that formula trims some spaces... So what.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Longest Formula Ever

    I didn't goto the link (Ozgrid is one of the ugliest websites I've ever seen) but that formula looks like it's one of those "words to numbers/numbers to words" functions that are popular in Asia.
    Last edited by Tony Valko; 09-01-2013 at 05:19 PM. Reason: added a missing word!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Longest Formula Ever

    Quote Originally Posted by Tony Valko View Post
    I didn't goto the link (Ozgrid is one of the ugliest websites I've ever seen) but that formula looks like it's one of those "words to numbers/numbers to words" functions that are popular in Asia.
    Tony, I was just kidding. I started to get nauseated only 1/4 of the way through it, although it does work pretty good.

  4. #4
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Re: Longest Formula Ever

    Quote Originally Posted by Tony Valko View Post
    ...Ozgrid is one of the ugliest websites I've ever seen...
    Is that strange thing to say? OzGrid and ExcelForum run same software and the even the color scheme is same.

    Don't want start disagreement, just my comment

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Longest active member
    By pike in forum The Water Cooler
    Replies: 2
    Last Post: 11-10-2011, 03:44 AM
  2. Replies: 4
    Last Post: 05-19-2011, 08:37 AM
  3. Formula for avg skip, max skip, longest out
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2010, 04:56 PM
  4. Find the longest run of 0's in a column
    By Ben_z_ in forum Excel General
    Replies: 7
    Last Post: 11-10-2008, 11:59 PM
  5. Longest Time
    By Brento in forum Excel General
    Replies: 1
    Last Post: 10-03-2006, 10:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1