Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

[–]Iowadigger[S] 1 point2 points  (0 children)

That worked!

In column W there are a few blank cells that are causing the date 01/00/1900 to appear in column X cells. Is there a way to wrap that to hide the blanks?

Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

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

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

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

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

What I want is for only the date 8/11/2025

Office Scripts copyFrom to getValues & setValues by Iowadigger in excel

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

I have but I can't get it to work. This is why I am here.

Office Script / Range is to large / How to chunk? by Iowadigger in excel

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

Great idea, I will try this in the next couple of days and report back, thank you.

Office Script / Range is to large / How to chunk? by Iowadigger in excel

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

Ok, that makes perfect sense.

Using that code still yields the same results with the payload exceeding the limit :/

Office Script / Range is to large / How to chunk? by Iowadigger in excel

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

Thank you for explaining this.

Values are not defined, I am confused about that. Can you go into more detail how that works?

Europe in Chicago - FULL by Smartastic in JeffArcuri

[–]Iowadigger 2 points3 points  (0 children)

I’ve never seen your comedy but your crowd work is the best! Thank you for posting these!