Menu

Creating sequential numbers plus a letter

Search this Thread

Previous Post

Next Post

#2

Report Post

Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

Creating sequential numbers plus a letter

Hi,

Am Wed, 12 Feb 2014 10:28:21 -0800 (PST) schrieb :

I am trying to make a list of numbers plus a letter:
00000001A
00000002A
00000003A

in A1 try:
=TEXT(ROW(A1),"00000000")&"A"
and copy down

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating sequential rows	PVT	Excel Programming	14	March 18th 09 03:16 PM
creating formulas for sequential numbers in excel	tacks	Excel Worksheet Functions	4	June 12th 08 05:08 AM
Creating part # tags using sequential numbering.	Andrew M.	Excel Discussion (Misc queries)	2	November 28th 06 08:04 PM
Creating sequential variables on the fly	ForestRamsey	Excel Programming	3	November 16th 05 08:11 AM
Creating a list in sequential order	Mark Jackson	Excel Worksheet Functions	6	November 7th 05 11:08 PM

All times are GMT +1. The time now is 06:03 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement