ExcelBanter - Access - Filling Blanks

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Access - Filling Blanks (https://www.excelbanter.com/excel-worksheet-functions/7255-access-filling-blanks.html)

wal50

Access - Filling Blanks

I have records that have blanks in one field. I want to put the same value
in all of them. How can I do this? Replace doesn't seem to work for Blank
fields

wal50

Frank Kabel

Hi
- select the data range
- hit F5, click 'Special' and choose 'blank cells'
- enter your value and hit CTRL+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"wal50" schrieb im Newsbeitrag
...
I have records that have blanks in one field. I want to put the same
value
in all of them. How can I do this? Replace doesn't seem to work for
Blank
fields

wal50

All times are GMT +1. The time now is 10:59 AM.