Ex Excel IV - Admin Automated

Challenge: Is it possible to split a CamelCased column to two columns Word 1 and Word 2? Some rows are expected to have only one capitalized letter, in that case display an empty value for Word 2.

Image 1. Input with column CamelCased to split into two columns.

Image 2. Expected output after splitting, showing two new columns.

Try it yourself, using this template.

[Form Placeholder]