I have an excel formula that takes the contents of a name in column B, then does this:
- Extracts the first letter of the Last name
- Extracts the first letter of the First name
- Extracts the first letter of the Middle name
It'll then attach the date in Column A to create a String, then places it in Column C (please see attached below).
Here is the formula:
81," ",REPT(" ",LEN(B81))),LEN(B81))),1)
Can someone simplify it so that we can disregard the Middle Name altogether? I just want the first char of Last, first char of First, then combine the date.
Thanks in advance.