Forum Discussion
mesmrc
Jun 08, 2022Copper Contributor
If cell starts with a blankspace, delete it
Is there a macro I could run that would check all selected cells and if some of them have a space at the beginning of them, it would delete that space leaving just the rest of the content? For ex...
PeterBartholomew1
Jun 08, 2022Silver Contributor
A worksheet function that will produce a clean copy of the data is
= TRIM(list)
VBA or TypeScript is needed to alter the original.
- mesmrcJun 10, 2022Copper ContributorThanks Peter!!