Alphabitize function

[Ipsl]

Is there a formula that when I take several letters from several cells in to one to alphibitize them

=LEFT($E8,1)&LEFT(G5,1)&" "&MID($E8,2,1)&MID(G5,2,1) &" "&RIGHT($E8,1)&RIGHT(G5,1)

Thats what I have and I was thinking like

=LEFT($E8,1)&LEFT(G5,1)ALPHA&" "&MID($E8,2,1)&MID(G5,2,1)ALPHA &" "&RIGHT($E8,1)&RIGHT(G5,1)ALPHA

but I dunno what the function would be

[VBA Noob]

Take a look in excel help for Upper & Proper case

VBA Noob

[Ipsl]

that changes the case of the letters and the case up the letters is critical for other calculations. So I didnt see anyhting about alphabetizing them. This is an example of the result: zA aB tm. I would like to have it say Az aB mt

[VBA Noob]

Proper case will change text like zA aB to Za Ab


VBA Noob

[NBVC]

Proper case will change text like zA aB to Za Ab


VBA Noob

I think the OP means to rearrange the resulting characters in alphabetic order

[Ipsl]

I think the OP means to rearrange the resulting characters in alphabetic order

yup exactally what I mean. but still stay in there original two