Splitting Variable Length Cell Information

[graemematthew]

Does anyone know a way of splitting the contents of a cell that can be of differing lengths in three or more cells ie we have the name Mr Graeme Berry in a cell and want to have Mr appearing in the first cell, Graeme in the next cell and Berry in the final cell. On the next line I have a Mrs Ann Walker and will want to split this Mrs, Ann, Walker.

Any ideas?

Graeme

 

[mbarron]

Highlight the cell you want to split. Go to Data/Text to Columns... The wizard should be able to show you the method from there.



Mike

 

[xlbo]

or via formulae
in 1st cell:
=Left(A1,find(" ",A1,1)-1)
in 2nd cell
=Mid(A1,find(" ",A1,1)+1,find(" ",A1,find(" ",A1,1)+1)-find(" ",A1,1))
in 3rd cell
=RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1,1)+1))
where your name is in A1

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244