Hi guys,
I'm a complete noob so please bear with me. What I need is an office script (as this needs to be run from a Power Automate flow).
I have a table which contains my data (which has been extracted by the flow).
It's a requirement that the data is converted to UPPER case. This is what I'm stuck on.
This was created using the "Record" function in O365 Excel.
1. I create a new worksheet.
2. Target A1
3. =UPPER(Extract) <-- name of table is Extract.
4. I manually selected the cells that make up the table.
5. Pasted values into original sheet (called Table) cell A2.
6. Delete the temporary worksheet.
It works... kinda! However, I need a way to only copy the cells that contain the UPPER data (from new worksheet). As you can see, it selects the range A1:AQ12 because at the time of recording, there were 12 rows and 43 columns.
The number of rows is dynamic, sometimes it will be more than 12 or less. The number of columns is always going to be 43.
What I'm looking for ultimately is for an office script that will replace the data in my main worksheet with UPPER case characters.
And as I mentioned, it needs to be an office script as that's a function that can be run from Power Automate (this is an automation I'm building).
Any help would be great.
Bookmarks