Are the part numbers always the same length? An example of some of the data
would help. you could use text to columns, or the RIGHT, LEFT, MID funtions
but it all depends on what the data looks like.

"Richard" wrote:

Hi,

I have a column that contains part numbers and a brief, one word,
description. I would like to seperate the description from the part numbers.
The list is pretty long and would rather use a function than to do it
manually. So, is there a function or formula that will do this?


Thank You,

Richard