LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Creating sequential numbers plus a letter

Hi all!

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

I have tried to put the number in the first column and the letter in the second and use the formula =A1&""&B1, but its not working.

Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"