Start text with the Alphabets omitting preceeding blank space number and full stop (.).

Hello Friends

Kindly refer the attached file <Start text with the Alphabets 111215.xlsx>

From Column A the proceeding number / full stop (.) / space should be removed and the line should start with alphabet. In End only blank space should be removed.

And the text should be plotted in the light yellow cells by formulas.

thanks in advance

thilag

Put this formula in C2:

=IF(TRIM(A2)="","",RIGHT(TRIM(A2),LEN(TRIM(A2))-FIND(" ",TRIM(A2))))

then copy down.

Hope this helps.

Pete

thanks Pete

thilag