Text alignment in a cell

  • I have a column containing the values as below

    asdafdafa,v.

    asdadad,a.

    sawqdqaf,b.

    asdas,x.

    wretweftettt,s.


    i need to align the above text in the below format

    Code
    1. asdafdafa, v.
    2. asdadad, a.
    3. sawqdqaf, b.
    4. asdas, x.
    5. wretweftettt, s.


    Can you please help?

  • All the initials v., a., b., x., s. Must align in a straight line in their respective rows

  • Presuming that your names are in column A from row 1 and have a single comma and a 2 charcter initial you could use this macro. To keep the initials aligned you will have to format the column with a monospaced font (ex. Courier New).