I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it in the cell?
I have checked over an over again to verify there is no extra space in the formula in Make. I have also changed my formula to +2, +2.
Variations of this MID formula works with other use cases, this is the only one inserting an extra space. Is there a better way to do this?
MID(
{Summary},
FIND(
':',
{Summary}
)+1,
FIND(
',',
{Summary},
FIND(
':',
{Summary}
)
)-(FIND(
':',
{Summary}
)+1)
)
