For Example, lets say you are given with Employee name and their ID and you would like to combine Initial letter of Last Name, First Name and Employee ID to create Employee Code. For that, you just need to type that pattern in adjacent column for any one of the row data and then just press Ctrl+E to flash fill for all the rows of data as shown below:
To learn many such useful Excel features, attend our comprehensive Excel Courses in Singapore. It is 100% subsidised by SkillsFuture Credit for all Singaporeans above 25 years of age. For others, special discounts available. For Enquiries, please call 66699754 or e-mail to firstname.lastname@example.org.