S
saman110 via OfficeKB.com
Hello all.
I am looking for a macro that looks in Col. B and if each cell does contain
anything other than N, S, W, E, NE, NW, SW, SE, WN,WS, ES, EN would move it
to the right.
ex.
Col. A Col. B
1 N
2 Sam
3 W
4 Tom
5 NE
Result:
Col. A Col. B Col. C
1 N
2 Sam
3 W
4 Tom
5 NE
Thx.
I am looking for a macro that looks in Col. B and if each cell does contain
anything other than N, S, W, E, NE, NW, SW, SE, WN,WS, ES, EN would move it
to the right.
ex.
Col. A Col. B
1 N
2 Sam
3 W
4 Tom
5 NE
Result:
Col. A Col. B Col. C
1 N
2 Sam
3 W
4 Tom
5 NE
Thx.