kamiltech.com
How To Extract first letter of each word from sentence in Excel - KAMIL
Supposing you have a list of countries’ name in your worksheet, and now, you need to extract the first letter of each word in the cell as following screenshots shown. Normally, there is no direct feature to pick up the first letter of each word in Excel. But, here, I can talk about a useful way to solve this task.