I need an EXCEL formula that will extract the 1st char from a cell and then prefix and suffix the extract character.
CLIC (LITCHFIELD INTERNATIONAL INC)
SURFACE TECHNOLOGY, INC.
I need to take extract the first char from all cells in column A and prefix with "Sup-" and suffix with "-Index". For the data above, the expected outcome would be: