Hey there, wanna hear a secret


Postby BeerCur on Sat Aug 04, 2012 6:15 pm

I need to find a better hobby... This is an Excel cell formula... Could have done it 15 minute in .net, but the challenge to do it in a restrictive environment... priceless or one night of struggle in exchange

-FIND("|",SUBSTITUTE(C91," ","|",LEN(C91)-LEN(SUBSTITUTE(C91," ",""))
,RIGHT(B91,LEN(B91)-FIND("|",SUBSTITUTE(B91," ","|"
,LEN(B91)-LEN(SUBSTITUTE(B91," ",""))-(LEN(B91)
The Dog of Beers
User avatar
Site Admin
Posts: 133
Joined: Mon Aug 26, 2002 4:43 pm
Location: USA - PA

Return to Announcement


Users browsing this forum: No registered users and 1 guest

Design by GB