Forum Discussion

DoubleDiamond52's avatar
DoubleDiamond52
Copper Contributor
Dec 07, 2022

Inserting static characters at beginning and end of a cell content

Hi.   I am trying to clean up a spreadsheet before exporting it for import into another system.  I've noticed some of the data includes spaces at the end of it and I need to identify all of those c...
  • HansVogelaar's avatar
    Dec 07, 2022

    DoubleDiamond52 You could use ="X"&A1&"X" in B1, then fill down.

    But I'd use =TRIM(A1) in B1 instead. This will remove leading and trailing spaces.

    You can then use column B for the export.

Resources