I have a column which contains a product description (in text) and
catalogue/EAN number (numeric). The description varies in terms of number of
characters whereas the catalgoe number doesn't. I want to right justify/align
the column and then text-to columns so I can pick the number away from the
original column - a kind of reverse concatenate. Any suggestions out there?

"Simon Ryan" wrote in message
...
I have a column which contains a product description (in text) and
catalogue/EAN number (numeric). The description varies in terms of number
of
characters whereas the catalgoe number doesn't. I want to right
justify/align
the column and then text-to columns so I can pick the number away from the
original column - a kind of reverse concatenate. Any suggestions out
there?

Are you questioning how to right-justify the data, or what to do next, AFTER
justifying?

Simon,

Try using, for example

=VALUE(RIGHT(TRIM(A1), 10))

where A1 is a cell with the data, and 10 is the length of the EAN number. Copy down to match.

HTH,
Bernie
MS Excel MVP


"Simon Ryan" wrote in message
...
I have a column which contains a product description (in text) and
catalogue/EAN number (numeric). The description varies in terms of number of
characters whereas the catalgoe number doesn't. I want to right justify/align
the column and then text-to columns so I can pick the number away from the
original column - a kind of reverse concatenate. Any suggestions out there?

Cheers - spot on!

"Bernie Deitrick" wrote:

Simon,

Try using, for example

=VALUE(RIGHT(TRIM(A1), 10))

where A1 is a cell with the data, and 10 is the length of the EAN number. Copy down to match.

HTH,
Bernie
MS Excel MVP


"Simon Ryan" wrote in message
...
I have a column which contains a product description (in text) and
catalogue/EAN number (numeric). The description varies in terms of number of
characters whereas the catalgoe number doesn't. I want to right justify/align
the column and then text-to columns so I can pick the number away from the
original column - a kind of reverse concatenate. Any suggestions out there?