Barryj
06-28-2011, 11:16 PM
I have attached a file with info in column A, does anyone know how I could delete all the info on the right of the name.
I only want the name of the person to be left; line 5 for instance would be left with Warren, J and nothing else.
As everyones names are different lengths I think this may not be able to be done, any thoughts or ideas would be greatly appreciated.
I only want the name of the person to be left; line 5 for instance would be left with Warren, J and nothing else.
As everyones names are different lengths I think this may not be able to be done, any thoughts or ideas would be greatly appreciated.