Forum

Notifications
Clear all

Looking for Perfect Formula for data cleansing - Pls Help

18 Posts
2 Users
0 Reactions
223 Views
(@jithu-joval)
Posts: 10
Active Member
Topic starter
 

Hi Mynda,

It did work, but i had white spaces in between the texts also. Unfortunately, Trim under Transform tab didnt remove it. Any other ways? 

 
Posted : 28/07/2020 12:18 am
(@mynda)
Posts: 4761
Member Admin
 

Please start a new topic and upload an Excel file with a sample of the problem data. There are probably some non-printing characters in the data that you need to identify so you can tell Power Query what to remove.

Mynda

 
Posted : 28/07/2020 3:24 am
(@jithu-joval)
Posts: 10
Active Member
Topic starter
 

Okay Mynda.

 
Posted : 29/07/2020 12:38 am
Page 2 / 2
Share: