I have many excel files and I want to rename their columns which contains (Employees) .
But in some Excel files there are 5 Emploee columns and sometime only one
How can I deal with this
Thanks!
Hi @Sami_Rajput
You can use find and replace till nothing is found
Or
Read the row and loop through use a if condition to check the name and if employee modify…if not move to next
Cheers