I have a column that has data in it mixed with spaces that are uneeded. I
want to create another column next to it with the same data in it but without
the spaces.

ie

A B
1 a | a
2 | d
3 d | c
4 |
5 c |