As per sample attached workbook in column A I have some data always in the formats as per the sample sheet. I want a formula to find the first single text character in the cell and to return that character and all to the right of it. Any help would be awesome.
Example data as per workbook is 'SMITH J A' and I'd want the output to be 'J A'
Bookmarks