Thanks, that solves the problem of splitting the line of data, and so easy.
Is there any way of selecting the relevent lines from all the info in the
column?
--
Thanks Bob


"Gord Dibben" wrote:

See response to one of your other posts on this subject.


Gord Dibben MS Excel MVP

On Sun, 4 Nov 2007 14:11:02 -0800, Bob wrote:

column 1 consists of words seperated by backslashes. (A .GED file) There are
instances of the first word being "name" ie name/robert/smith but they
are not evenly spaced ie c1,c4,c7,c10. I can read the first instance with
=VLOOKUP("name",A1:A50,1,) or =INDEX(A1:B50, MATCH("name",A1:A50,),2) how can
I read further instances of the word "name" appearing so that I can put the
info in a new column. ie

score/seven
name/alan/jones
name/alan/jones
name/robert/smith
time/late
age/old/wise
name/robert/smith

or even better just put Jones and Smith in the new columns?