Remove multiple spaces from column names words

[SunnyJha]

I have an excel in which the column names can contain multiple spaces between them.
For ex: Invoice Data is written as Invoice Data (multiple space).
I want to rename such columns with proper names by only keeping one space between each word.

[adiijaiin (Aditya Jain)]

Hi @SunnyJha

Use this Expression to remove the spaces: Regex.Replace(STR, " {2,}", " ")
Iterate through the column names

Input Screenshot:

Solution
RemoveSpacesFromColumns.xaml (9.1 KB)
Sample.xlsx (8.7 KB)

Output Screenshot:

The solution attached will replace all the column names in your file with single spaces and remove the additional Space at the end of column name as well.

Thanks
Happy automatioN!

[Parvathy (PS Parvathy)]

Hi @SunnyJha

Can you share sample input and expected output.

Regards