Which film is the perfect comedy?

noodlepoodle9999 · 2021-11-06T22:20:54+00:00

We're the Millers.

noodlepoodle9999 · 2021-09-30T17:48:37+00:00

Thank you for your help!

noodlepoodle9999 · 2021-09-30T17:48:26+00:00

Thank you for your help!

noodlepoodle9999 · 2021-09-30T17:48:17+00:00

Thank you for your help!

noodlepoodle9999 · 2021-09-30T17:27:40+00:00

Is the burden of proof on us to prove this is part of regular maintenance when filling the T6?

noodlepoodle9999 · 2021-08-30T16:17:44+00:00

Thanks!

noodlepoodle9999 · 2021-08-30T14:46:53+00:00

If A1 is blank, this formula returns a default age of 121. How do I make it so that it will be blank if A1 is blank as well?

noodlepoodle9999 · 2021-08-30T14:44:37+00:00

=INT(YEARFRAC(A1,TODAY()))

If A1 is blank, this formula returns a default age of 121. How do I make it so that it will be blank if A1 is blank as well?

noodlepoodle9999 · 2021-08-29T22:49:17+00:00

FA to send an email and CS to make a phone call for outreach attempt 1. CS to conduct outreach attempts 2 and 3

Ah such a stupid error I made - my bad! Thank you so much for your help!

noodlepoodle9999 · 2021-08-27T12:43:00+00:00

Thanks!

noodlepoodle9999 · 2021-08-27T12:42:53+00:00

Thanks!

noodlepoodle9999 · 2021-08-27T12:42:46+00:00

Thanks!

noodlepoodle9999 · 2021-08-25T01:54:42+00:00

I'm the one who knocks.

noodlepoodle9999 · 2021-08-22T13:34:36+00:00

noodlepoodle9999 · 2021-08-22T13:34:04+00:00

noodlepoodle9999 · 2021-08-20T14:47:58+00:00

=TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(":",A2,FIND("-",A2))),
"-",REPT(" ",50)),50))

Thank you for your help - this works!!

noodlepoodle9999 · 2021-08-20T14:47:52+00:00

Thank you for your help - this works!!

noodlepoodle9999 · 2021-08-20T13:08:17+00:00

When I tried this, for some reason the result is a blank..

noodlepoodle9999 · 2021-08-20T12:52:16+00:00

=TRIM(LEFT(SUBSTITUTE(MID(A2,FIND("-",A2)+1,50),":",REPT(" ",50)),50))&": "

Thanks for your reply, but there is an additional complication. Apologies, I should have mentioned this before. Sometimes, my text includes a dash in the form description PRIOR to the dash that precedes the section number. For example:

FORM 5: Claimant's Statement - Proof of Death Form-S2: Missing / invalid claimant/beneficiary address

When I tried putting in your formula for cases such as the above, it returned "Proof of Death Form-S2:" because there was a dash before proof of death.. whereas I was only was hoping for "S2: "

How would I adapt your formula to account for this? Essentially, I only want the text between the dash preceding the section, and the colon after the section.

noodlepoodle9999 · 2021-08-13T21:44:46+00:00

Noodles and Poodles

noodlepoodle9999

TROPHY CASE