I have a spreadsheet that looks like this:
Invoice # Item Code #1 Item Code #2 Item Code #3 Etc Etc
1 1 5 9
2 66 47
3
4 5
5 47 66
6 5 7
7
8
9
10 5
The numbers are different, but is there an easy way to move any field with a character in it to the left as far as it will go. I want it to look like this when finished:
Invoice # Item Code #1 Item Code #2 Item Code #3 Etc Etc
1 1 5 9
2 66 47
3
4 5
5 47 66
6 5 7
7
8
9
10 5
Any help would be great,
Thanks in advance,
Chad
Bookmarks