MS Excel Query
Posted on 2012-04-10
I am trying to combine 3 columns into 1. I have a column for First Name, Last Name and Middle initial. My combined cloumn is: Last Name+', '+First Name+' '+Middle initial.
The problem is, if the person does not have a middle initial then nothing is shown.
How do I get My combined column to reflect the Last Name and First name only if no middle initial is present.
Thank you in advance.