Hi!
Is there a way to find blank cells in a selection and then replacing those cells with text in an Excel spreadsheet?
I know you can use find and replace in the actual Excel desktop program to look for 'null' values and replacing it with text, but Power Auto for Desktop doesn't seem to work with just a blank for the 'Text to Find'. Putting something like null', empty(), or even %' '% doesn't work either.
Any help would be greatly appreciated!
