Fill down a column that is text not working, need help to trouble shoot

[Anonymous]

I have two columns I need to fill down. One column is numeric and it fills down fine (Column6 below). The other column is text but it won't fill down (Column1 below). Does the fill down not work with text? Is there another work around?

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please replace the value " " in Column1 with null, and then fill the value down to check if works well...

1. Replace the value " " in  Column1 with null (select "Column1",right click and choose "Replace Values...")

2. Fill the value down after replaced the value (select "Column1",right click and choose "Fill"-->"Down")

Best Regards

Rena

[LRSF]

Thank you very much. Quick as a flash!

[Anonymous]

Thank you so much as this worked, I was spending hours on this!

[Greg_Deckler]

I can't get it to work in a text column.

[Nishantjain]

@Anonymous 

The fill down works if the cells the empty. Looking at the screenshot, it seems they are not empty but whitespace. Usually, the empty cells are shown as null. To get around it, try the following in Column1

1. Use "Replace value" option with following options
   1. Value to find =  ""
   2. Replace with =  null (without any quotes)
2. Now try to fill down

Thanks