I have a a long list of information containing a varying number of words. I need to take the first word in each cell and move it one cell to the left. I have been using the below macro:
Please Login or Register to view this content.
The problem I have with the above is that if there is only one word and therefore no space for the code to find it spits out an error.
Could I add in an IF statement to say: (IF there is no " " then move data left)? If so how should I write this in?
Thanks in advance.
Bookmarks