Good morning,
I recently pulled a list of golfer names from a folder and I need to add a space between the first and last names. The first names are all in lowercase and the last names are all in uppercase:
tigerWOODS
philMICKELSON
jordanSPIETH
maxHOMA
I found a formula in this thread and it's very close to what I'm looking for. But I want to put the space between the last lowercase and first uppercase letters and it has to work for a list of 200 people. How would I do that?
Thanks,
MSP
I recently pulled a list of golfer names from a folder and I need to add a space between the first and last names. The first names are all in lowercase and the last names are all in uppercase:
tigerWOODS
philMICKELSON
jordanSPIETH
maxHOMA
I found a formula in this thread and it's very close to what I'm looking for. But I want to put the space between the last lowercase and first uppercase letters and it has to work for a list of 200 people. How would I do that?
Thanks,
MSP