lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have table like the one below, have some empty cells. I want to fill these cells with word "Absent"
I used Power Query and then clicked on "Replace value" and then entered replace "Null" with "Absent"
but power query did not accept "Absent", it asked me to enter numberic value.
I had to change the format of the column to Text and then replaced "Null" with "Absent"! but I remeber
very well I did not have to change the format of the column to text and then replace Null with Absent but
I forgot how I did that. Any idea please. Thank you.
I have table like the one below, have some empty cells. I want to fill these cells with word "Absent"
I used Power Query and then clicked on "Replace value" and then entered replace "Null" with "Absent"
but power query did not accept "Absent", it asked me to enter numberic value.
I had to change the format of the column to Text and then replaced "Null" with "Absent"! but I remeber
very well I did not have to change the format of the column to text and then replace Null with Absent but
I forgot how I did that. Any idea please. Thank you.
| 100 |
| 344 |
| 222 |
