how to take out some data from an excel cell

[harisonford]

how to take data form an excel cell
by a formula specifing the data it self
followed by a certain number of characters

4-a-a-c,5-a-b-c,6-a-b-c,

i want to get only 5-a-b-c and put them in aonther cell ,by saying give me 5 and 6 characters after it

 

[VoG]

Try

=MID(A1,FIND("5",A1),7)

 

[harisonford]

many thanks it works

 

[harisonford]

now how about if 5 is followed by 6 characters
then in another cell by 5 characters in the same colouim

and i want to creat a coloum that will take 5 and then 4 characters

 

[VoG]

Maybe?

=MID(A1,FIND("5",A1),LEN(A1)-FIND(",",SUBSTITUTE(A1,",","~",1))-1)

 

[harisonford]

please see my other question about combining data in many excel sheets
into one on top of each othe vertically