Excel 2010 formatting to use letter and number combination / alpha-numeric

Hi,
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi and welcome to the forum

I am really confused. You want HO1200237 to look like AU1000910 after you enter it? How so??

Except for using data- Sort A to Z, i don't know any method for sorting automatically. There must be a VBA answer somewhere though. I'll let you know if I can find one. I hope one of our VBA guru's ( or whatever the well-versed members are called) can help.

Hi Howie,
don't get frustrated because you get no answer. It sometimes takes a while before threads are solved. I think you will need a VBA solution to do the sorting automatically. Perhaps ask a mod or an admin to move your question to the appropriate forum?

Good luck, and don't forget to bump your thread once in a while

I did some homework and found this piece of code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
    Cancel = True
    Columns("A").Sort Key1:=Range("A1"), Order1:=xlAscending, _
    Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End If
End Sub

To implement it ; right click the sheet's tab, click view code - Copy paste the code in the window that opened - then save it.
The code only works for col A
Each time you add a row to that col, it will autosort on exit

well its easy enough to sort with a helper but it relies on them being unique
in b1 put
=COUNTIF(A:A,"<="&A1)
in c1 put
=IFERROR(INDEX(A:A,MATCH(ROWS($A$1:A1),B:B,0)),"")
fill both down as far as you think you'll need