Clear a cell in Microsoft 365 Excel

Using the “Update a Worksheet Row” module in the Microsoft 356 Excel app, how do I specify a cell should be cleared?

I have tried the null, erase, emptystring and emptyarray literals but they all keep the existing value in the cell.

Using something like space will populate the cell, but that isn’t the same as clearing it and functions like ISBLANK will evaluate false.

Welcome to the Make community!

According to How to: Clear Cells of Content, Formatting, Hyperlinks and Comments | Office File API | DevExpress Documentation, null should work, if it doesn’t it might be a bug in the module.

For technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your account or scenario might not be suitable for an open forum discussion.

You can open a new ticket here, or if you are unable to login for some reason, you can create another new free account to access the ticketing system (which is only available to logged-in users). After submitting a new ticket, you will receive an automatic confirmation email with the subject “Ticket Created” in the subject. If you do not receive this, try sending the ticket again.

If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.