Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Letter at end of number sequence

I am trying to add a certain letter (H) to the end of a numerical sequence in a spreadsheet but cannot get it to populate on its own without changing the numerical sequence. For instance I have it in excel as
12G10000
12G10001
12G10002.. and so on but i need to the letter H so that it looks like

12G10000H
12G10001H
12G10002H.. and so on but when I add the letter and then do the usual highlight and drag down it changes the sequence so that all of the subsequent numbers are the same as the first highlighted cell.

any suggestions?
Reply
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
Capitize first letter in sequence dberger16 Excel Worksheet Functions 2 April 20th 08 12:46 AM
change headers from letter to number/number to letter lazybee Excel Worksheet Functions 1 July 29th 05 11:08 PM
column header changed from letter to number, how return to letter Ron Excel Discussion (Misc queries) 2 May 9th 05 08:34 PM
How do I get the columns in Excel to go back to letter sequence Lostinexcel Excel Discussion (Misc queries) 0 April 27th 05 11:41 PM
How do I get the columns in Excel to go back to letter sequence Gary's Student Excel Discussion (Misc queries) 0 April 27th 05 11:18 PM


All times are GMT +1. The time now is 02:27 AM.

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"