Unanswered: Separating Data in one cell to multiple cells
I have an excel file that contains 4 different data items in a single column separated by a <space>. I need to write a subroutine that separates the string of characters in the cell based on the positions of the <spaces>.
Example string "France Adam Down Holiday"
Dont think there is a combination of spreadsheet excel functions that will do this. Therefore will have to write some visual basic code.
Need some help here if possible in a little bit of code.
Im thinking a combination of "Instr" and "Left" VB functions will do this for me. Is there a simpler way of splitting the string using other string manipulation functions?