Hello
I have a cell in my spreadsheet that contains a persons name.
I'd like to split the cell, or rather copy the firstname and surname, into two different cells. Obviously, the split point would be the space inbetween the two names but I can't work out how to do this!
I thought about using the e.g. =(LEFT A1,5) method, but the firstnames are all different lengths, so this would be no good.
Any help you could give me would be much appreciated!
Cheers,
Jon
I have a cell in my spreadsheet that contains a persons name.
I'd like to split the cell, or rather copy the firstname and surname, into two different cells. Obviously, the split point would be the space inbetween the two names but I can't work out how to do this!
I thought about using the e.g. =(LEFT A1,5) method, but the firstnames are all different lengths, so this would be no good.
Any help you could give me would be much appreciated!
Cheers,
Jon