In Excel 2010 i have a colum that has names like Mike, Mike E. Mike E. Jones, etc i would like to strip off everything after a space, if a space does not exsist to use what is in there.
Michael E. "Mike"
So in this example it would return a Robert, Michael, Maryeann, Stephen in the new column. Also, I want to combine 3 columns into one new one only using the first 4 characters in the last column. Example:
Bolan Jared 19890705
So the new column would contain: bolanJared1989