Forum Discussion
DoubleDiamond52
Dec 07, 2022Copper Contributor
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...
- 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.
HansVogelaar
Dec 07, 2022MVP
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.
- DoubleDiamond52Dec 07, 2022Copper Contributor& of course. Didn't know about TRIM though so that is brilliant for future use. Thanks for your help.