Need to KEEP spaces in otherwise empty text fields

[Jaxtraw]

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

[Sho · Accepted solution]

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

TRIM(string)

[Jaxtraw]

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