Video 00079 Find the 2nd upper case letter in a name @MySpreadsheetLab
Video 00079 Find the 2nd upper case letter in a name @MySpreadsheetLab
Uploaded February 2014 | Updated September 2026, 52 minutes ago
Get Excel file 00079 here: http://1drv.ms/1bYwrTa

Given a long list of names like this -BabeRuth- you need to split the names into 'first name' and 'last name'. You could use vba (macro) code but an Excel array formula can also solve this.

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com
Video 00079 Find the 2nd upper case letter in a name00181 Extract largest number inside a cellVideo 00034 Largest City Per CountryVideo 00035 Solution_Dynamic array HYPERLINKVideo 00068 Create a Random DatasetVideo 00084 Multiple lookups using Excels OFFSET functionVideo 00063 URGENT TASK: Dynamic filter and subsearchVideo 00074 How many times do you need to raise a number to reach target?Video 00091 Remove Duplicates with a twistVideo 00008 Features_Basic_FINDVideo 00137 Vlookup Returns Multiple ValuesVideo 00118 Think Like Bob Umlas Part 1_Are THESE cells referenced in THAT formula
Kevin Lehrbass |

Video 00079 Find the 2nd upper case letter in a name

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER