Every day I need to do the following 70 times by hand:
+ Cell B1 > Cut (copy) everything up to BEFORE the last space, then add it to cell A1
+ Move to B2 > Cut (copy) everything up to BEFORE the last space, then add it to cell A2
+ Move to B3 > Cut (copy) everything up to BEFORE the last space, then add it to cell A3
...
A1 | B1| C1
First Name | Last Name X |Other Stuff
Should Result in :
A1 | B1 | C1
First Name Last Name | X | Other Stuff
Once First Name Last Name is in A1 same thing has to happen with the next line untill there is no more content.
Any way to script this?