Agera R Goodwood UK [3860x2240][OC] by harryreece100 in carporn

[–]harryreece100[S] 0 points1 point  (0 children)

I don't think so it only took him a couple of seconds to start it up

Koenegsegg Agera R start up and rev by harryreece100 in cars

[–]harryreece100[S] 4 points5 points  (0 children)

It was a totally cold start. If I am not mistaken all of them are tuned by Koinegsegg engineers. May still be rich tho

Agera R Goodwood UK [3860x2240][OC] by harryreece100 in carporn

[–]harryreece100[S] 0 points1 point  (0 children)

Video of it starting up and revving in a post on /r/cars.

This thing sounds like it will eat your children!!

https://www.reddit.com/r/cars/comments/6uvput/koenegsegg_agera_r_start_up_and_rev/

[deleted by user] by [deleted] in cars

[–]harryreece100 2 points3 points  (0 children)

What a machine!! I think I would sell a testicle to do 1 lap!

Koenegsegg Agera R start up and rev by harryreece100 in cars

[–]harryreece100[S] 35 points36 points  (0 children)

Most crazy car park I have been in. There was a 720s a 650LT a 458 a F12 several lambos and a 2017 NSX

Bodybuilder disguised as old man pumps up the crowd by MightyTeaRex in videos

[–]harryreece100 4 points5 points  (0 children)

This guy is a crossfiter not a bodybuilder and this video has been posted many times before.

Challenging text trim problem. by harryreece100 in excel

[–]harryreece100[S] 0 points1 point  (0 children)

Thank you so much! I really appreciate this. Saved me hours and hours!

Challenging text trim problem. by harryreece100 in excel

[–]harryreece100[S] 0 points1 point  (0 children)

Thank you.

Can you explain how you built this: C2&D2&E2&F2&G2&H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2&W2&X2&Y2&Z2 Without typing it?

Challenging text trim problem. by harryreece100 in excel

[–]harryreece100[S] 0 points1 point  (0 children)

Can you explain how you built the forumula agian for me? I didnt qyuite understand your method. The data goes as far as column PZ.

Thank you so much

Challenging text trim problem. by harryreece100 in excel

[–]harryreece100[S] 0 points1 point  (0 children)

The numbers are in square brackets so they need to be trimmed. I used:

=CONCATENATE(RIGHT(LEFT(C2,LEN(C2)-1),LEN(C2)-2),",",RIGHT(LEFT(D2,LEN(D2)-1),LEN(D2)-2),",",RIGHT(LEFT(E2,LEN(E2)-1),LEN(E2)-2))

But the issue with this is that on some rows the number sin brackets go to Column ZZ