open_in_new content_copy
=ARRAYFORMULA(PROPER(A2:A))
open_in_new MORE content_copy COPY

@Abhi at thiscodeWorks.com