Hello everyone,
I have this list of project codes that should be 3 characters only but shows up as 4 because of an invisible tab or whitespace that I do not see. I have used the data cleansing tool multiple times in a row but nothing is work. This is what I am getting.
| Project Code | Length |
| 124 | 4 |
| 145 | 4 |
I need the length to be 3. I have attached the list. I believe the whitespace/whatever it is/tab is on the left because when I use the left() formula it cuts off the last number. Ideally, I wouldn't use the right() formula as these rows are included in a big data sets with project codes longer than that and doing so would cut them off.
Thank you
