Now we will combine all the functions into a practical workflow.

Raw Data

Raw Name	Email	Employee ID	Company
SAROJ pensia	SAROJ@GMAIL.COM	EMP2026HR001	ABC Pvt Ltd

Cleaning Tasks

1. Name Cleaning

=PROPER(TRIM(A2))

Result:

Saroj Pensia

2. Email Cleaning

=LOWER(B2)

3. Employee Code Extraction

=LEFT(C2,3)

4. Year Extraction

=MID(C2,4,4)

5. Employee Number

=RIGHT(C2,3)

6. Company Name

=SUBSTITUTE(D2,”Pvt Ltd”,”Private Limited”)

In this way, multiple text functions can be combined into a single workflow.