MrExcel Publishing
Your One Stop for Excel Tips & Solutions

parsing out data


Posted by Verna Holmes on January 22, 2002 10:47 AM

i need to create a function that looks at a cell of data (4 words - separated by a blank space)

the last set of characters begins with the same characters throughout the database

i want that set of characters copied out of that cell and pasted in the one next to it

does anyone know how that is accomplished

thanks,
verna


Posted by on January 22, 2002 10:52 AM

Can you provide some examples? (NT)

Posted by IML on January 22, 2002 10:57 AM

If your key is zero, you could try
=RIGHT(A1,LEN(A1)-FIND("zero",A1)+1)
This assumes your characters are unique and cannot occur in your first three words.

You could also try
=RIGHT(SUBSTITUTE(A1," ",999,3),LEN(SUBSTITUTE(A1," ",999,3))-FIND(999,SUBSTITUTE(A1," ",999,3))-2)
to key off the thir space. this assume 999 will not occur anywhere else.