Thread: Generate alphanumeric unique 4 digit values from 12 digit values
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Generate alphanumeric unique 4 digit values from 12 digit values
DataText to ColumnsFixed WidthNext. Click after every 4th number to draw a
break line.

The NextColumn Data FormatText for each column(in case a 4-digit number has a
0 as first digit.

Finish.


Gord Dibben MS Excel MVP


On Fri, 9 Feb 2007 11:03:01 -0800, mikep
wrote:

I'm trying to convert 12 digit strings to individually unique 4 digit strings
for product coding. Any ideas?

Reply With QuoteReply With Quote