Hi all,
How to make an selected column or row to capital words. with or without caplock?
Hi all,
How to make an selected column or row to capital words. with or without caplock?
Quick way is to insert a column and type =UPPER(A1). Copy down the column copy and paste as values and paste over original text. PROPER(A1) Will give you a capitalised first letter of each word.
Try this code:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks