Excel Magic Trick 1177

Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter

DESCRIPTION

See examples of how to use CONVERT function to convert from one unit to another unit.
(00:12) Flash Fill from YouTubers: Jorge Piris & Adeel Siddiqui
(01:38) Array formula based on CODE function from YouTuber: Bill Szysz