View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Simon Ryan
 
Posts: n/a
Default Text to columns - right-aligned text

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?