Here are some examples:

CYAN C4815A
MAGENTA C4816A
YELLOW C4817A

Color description and Part number need to go into seperate columns.

Richard



"CLR" wrote:

Yes..........Please provide a few examples....preferably to include both the
normal, and any extremes different from the most of them.

Vaya con Dios,
Chuck, CABGx3

"Richard" wrote:

Part numbers have numerals and letters, but they are all seperated by a
space. Is this what you are talking about?

Richard

"CLR" wrote:


It all depends on how the data is formatted. If the part number is all
numbers and the description is all alpha-characters, then ASAP Utilities is a
free Add-in available at www.asap-utilities.com that has features that will
strip out all the Alpha and/or all the numerical characters from a string.
If the two groups are always separated by a space or other unique character
then LEFT, Mid, and FIND can be used to separate the groups, or even Data
TextToColumns could be used..........please post back with more specifics and
someone will be glad to help....

Vaya con Dios,
Chuck, CABGx3


"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