New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

i want to generate alphanumeric code

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

i want to generate alphanumeric code

Postby ravee guptaa » Fri Jul 01, 2016 11:36 pm

Hi

I want to generate alphanumeric code from name mentioned in another cell.

For example : A2 = sumit , B2 = rakesh

I want A1 =sum001 and B2 = rak001

if in any cell code will repeat like sum001 then it should be converted to sum002

please help
  • 0

ravee guptaa
Rookie
 
Posts: 1
Joined: Jul 1, 2016
Reputation: 0
Excel Version: 2010

Re: i want to generate alphanumeric code

Postby Beamer » Fri Sep 02, 2016 11:54 pm

Hi ravee, try this in cell A1 and copy across as needed:-

Code: Select all
=LEFT(A2,3)&TEXT(COUNTIF($A$2:A2,LEFT(A2,3)&"*"),"000")
  • 0

Beamer
Excel Junkie
 
Posts: 217
Joined: Oct 3, 2014
Location: New South Wales, Australia
Reputation: 31
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 27 guests

cron