I have a list of names as lastname, firstname. I have a list of nine numbers
that need to be connected to the name, but I only need the first four
numbers. I need a formula to make them first initial (no period) lastname
followed by the four numbers. Also, the first letter of the lastname,
firstname are in uppercase and the whole name needs to be in lowercase, and
some names have a space at the beginning and I need to "trim" that space.
Does anyone know of an Excel formula or function that will do this?

An example is " Singh, S." (the name with the space at the beginning)
An example is "Wimberly, J." (the name with no space at the beginning)