Replacing a date formular result with another formular

Hi
I have a cell which cannot exceed 10 characters and will be info pulled from other cells.
My formula returns the start date and first characters of other cells to create a “short name”. I am looking for a formula that will return the date as the first two characters of the day, followed by the first and last characters of the month, followed by the date. This formula will be used in a sequence (by this I mean dragged to copy to the end date cell). If the start date in A1 is 2013/01/01. I would like Cell A2 to be TuJy01wxyz ("wxyz" being the first characters from other cells). I am using =TEXT(A1,"DDDMMMD"), but don't know how to replace it to shortend days and months. I am also looking for the option to have the replaced month to be the first and third characters of that month (though I will run into a duplicate for January and June, as they both have “N” as the third character.
Any help?

As well as 3 months beginning with J, there are 2 that begin with M, and taking the 3rd character of the month will, as you say, result in Jn for both January and June. To avoid this, you could take the 4th character if the month begins with J and thus have JU for January, JE for June and JY for July, but use the 3rd character for all other months. If that is acceptable, then you can try this formula:

=LEFT(TEXT(A1,"ddd"),2)&LEFT(TEXT(A1,"mmm"))&MID(TEXT(A1,"mmmm"),IF(LEFT(TEXT(A1,"mmm"))="J",4,3),1)&TEXT(A1,"dd")&LEFT(B1&"....",4)

assuming B1 contains the other characters that you want to add. If you put this in C1 and have other dates down column A and names in column B, then you can copy the formula down.

Hope this helps.

Pete

Post a sample workbook.

Hi Pete.
Thank you for your quick response. I will definitely use your formular as it has much better results.
I'm sorry I cannpt upload a sample file as I don't have the necessary permissions.

Hi protonLeah,
Thank you very much for your quick response too. It works fine. I don't have my permissions set to upload files, so have to explain what I need like this.

Hi mikeTron:
I'm sorry I cannpt upload a sample file as I don't have the necessary permissions, and though I have two responses, I definitely would welcome any suggestions you have - thanks.