Combine text from two or more cells into one cell in Excel
If you have more than one text values then excel allows you to use given ways to quickly combine text from two or more cells into one cell.
Concatenate function
Add or insert leading zeros to text or numbers in MS Excel
If you need to add leading zero to a value then read this article to provide quick way to add or insert leading zeros to text or numbers in Excel.