C
cas
I want to be able to use the replace command, but it won’t find the spaces
for me.
When I copy tables with numbers from various sources, I get spaces inside
and after the numbers. E.g. “1 234 “
I know the use of SUBSTITUTE and other functions, but it is not an effective
way of working when there are so many columns. I have tried to change the
cell format to text, but still no luck in finding the spaces with the replace
command.
for me.
When I copy tables with numbers from various sources, I get spaces inside
and after the numbers. E.g. “1 234 “
I know the use of SUBSTITUTE and other functions, but it is not an effective
way of working when there are so many columns. I have tried to change the
cell format to text, but still no luck in finding the spaces with the replace
command.