How To Remove Formatting in Excel Cells ( for One Column)?

[hsendel]

Dears,

How To Remove Formatting in Excel Cells ( for One Column)? without loosing Data on it ( Keep only Values instead of fucntions). Thanks in Advance

[Greg_Jacobson]

Try highlighting the cells, changing data type to general.

[hsendel]

Thanks @Greg_Jacobson , It’s one of the solution but it will not help my case as I have thousands of cells in that column.

[ManiPrajwal_K (Mani Prajwal Katta)]

Hey @hsendel, Have you tried using read range and write range activities?

You can remove all additional formatting just by reading the data and writing the same data.

[Sudharsan_Ka]

Hi @hsendel

Just give it a try
Use clear activity

Regards
Sudharsan