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

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

Try highlighting the cells, changing data type to general.

1 Like

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.

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.

1 Like

Hi @hsendel

Just give it a try
Use clear activity

Regards
Sudharsan

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.