Adds unnecessary spaces in Excel and Google Sheets formulas/scripts

API Bugs
1

Should I need assistance in creating a formula, it always adds unnecessary spaces in the formulas. I either have to ask it to remove them and hope it does or manually remove them myself.

1 Like
2

Could you give an example of a prompt?

1 Like
3

Sorry for the late reply. Here is one but suprisingly when I paste into here there are no extra spaces, but when I paste into a spreadsheet there are spaces.

=TRIM(LEFT(A78, FIND(“(”, A78) - 1)) & " " & MID(A78, FIND(“(”, A78), LEN(A78) - FIND(“(”, A78) + 1)