I like a quick and easy way to cut the text to the left of the first space of the active cell and paste that on to the cell on the left. Example as shown
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
4 | 1.01Thequickbrownfoxjumpsoverthelazydog. | |||||
5 | 1.01 | Thequickbrownfoxjumpsoverthelazydog. | ||||
Sheet1 |