Hi All,
I am having some issues trying to split names in Excel. I am aware of 'text to columns' but it doesn't quiet do what I am after. My data is show below -
GRILLO Emiliano
KRUGER Jbe
OTTO Hennie
LEE Craig
OLAZÁBAL José María
SINGH Jeev Milkha
VAN DER WALT Tjaart
I need to find a way to split the names by capital letters so they would read as below. That way I can use VLOOKUP in the way I want.
GRILLO Emiliano
KRUGER Jbe
OTTO Hennie
LEE Craig
OLAZÁBAL José María
SINGH Jeev Milkha
VAN DER WALT Tjaart
Whenever I try to split it I can't find a way to do it without using a space or comma etc. The space between Van and Der is where it goes wrong. Unfortunately I can't find a way to do this (Excel Novice!), so any ideas would be greatly appreciated.
Thanks all!
Ryan
Bookmarks