Skip to main content

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)
)

 

 

There is a TRIM function. It removes the extra spaces before and after.

TRIM(string)

There is a TRIM function. It removes the extra spaces before and after.

TRIM(string)


Thank you! That worked! I just wrapped the whole formula in TRIM ( )

Reply


Terms & Conditions