Forum

Notifications
Clear all

data cleansing

3 Posts
2 Users
0 Reactions
100 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Dear team,

I have to make all the numbers to null from (data type =Text) column, then I can fill down with the above name.

It is an opposite of changing data type to number where all the text become 'Error"

Please see my sample file for what I refer to.

Thank you.

 

regards,

Aye

 
Posted : 08/03/2019 6:17 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

Please see attached.

Mynda

 
Posted : 09/03/2019 2:36 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Thank you so much, Mynda.

It is a great help.

Regards,

Aye

 
Posted : 09/03/2019 9:23 am
Share: