macro to split text/number string

hi,

im looking for pointers in creating a macro to split a text/number sting up.

this is what i currently have in A1
aaaa 31st Jan - 19:50 1a2b bbbb
aaaa 1st Jan - 19:50 1a bbbb

however i need to chop it up! so the result in cells M1,N1,O1 are
M1 aaaa
N1 1a2b or 1a
O1 bbbb

I need this so i can perform a lookup based on M,N,O. They need to be in different cells (i think) as each result appears in a seperate column on the look up table.

or could i get a macro to perform the look up without splitting the A1 cell?

Hi

try a User Defined Function.

put the code below into a general module

Please Login or Register  to view this content.

M1: =myfunc(a1,1)
N1: =myfunc(a1,2)
O1: =myfunc(a1,3)

HTH

rylo

lol, so simple once you see it done. Thank you very much rylo +1
works like a dream and easly modified for my other sheets