There are not actually quotes in the string. I just have them to show there
are spaces in front and back. Also, the number of spaces can vary. The
first record may have 3 spaces in front and the second 5 and so on.....

' This is record one '
' This is record two '
'This is record three '

There are not really ' in the cell. I just included them to show all the
blank spaces.

How using a formula would you take the leading and trailing spaces away?

Thank you,

Steven