Formula to Find&replace blank cells in excel
Solved/Closed
onetuff_z

Feb 9, 2010 at 02:09 PM
tstobb Posts 1 Registration date Tuesday April 14, 2015 Status Member Last seen April 14, 2015  Apr 14, 2015 at 12:29 PM
tstobb Posts 1 Registration date Tuesday April 14, 2015 Status Member Last seen April 14, 2015  Apr 14, 2015 at 12:29 PM
Related:
 An example of a cell is a blank cell
 Excel vba replace blank cells with text  Best answers
 Find and replace blank cells in excel  Best answers
 Count if cell contains number  Excel Forum
 Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓  Excel Forum
 If cell contains specific text then return value in another cell ✓  Excel Forum
 Conditional formatting if cell contains text  Excel Forum
 Excel conditional formatting if another cell contains specific text ✓  Excel Forum
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 02:46 PM
Feb 9, 2010 at 02:46 PM
possible with macro
or if you can have this formula in b column and once done u can you copy and paste special as values to remove the formula
in b2 you can have some thing like this
=if (isblank(a2), a1, a2)
fill this formula down to last row
or if you can have this formula in b column and once done u can you copy and paste special as values to remove the formula
in b2 you can have some thing like this
=if (isblank(a2), a1, a2)
fill this formula down to last row
Oct 19, 2010 at 08:32 AM
Oct 24, 2011 at 07:58 AM
I have a similar problem with a small difference that I have the text in one cell and then several empty cells, then one nonblank cell and several empty cells. I would like to fill the empty cells with the text of the preceeding nonblank cell. When I tried the proposed formula =if (isblank(a2), a1, a2) in the adjucent column it gave me the desired result in the immediately following cell (because the above cell is not blank in the adjucent column) but after that started giving out "0" because in the adjucent column the cell is empty. How it is possible to bypass this problem? Please help
Oct 26, 2011 at 06:54 PM
=if (isblank(a2), a1, a2) says that if A2 is blank then show the value of a1, other wise show a2. So I am kind of lost. This is my best understanding. You are saying if there are more than one blank cell it gives a 0
if that is the case you can try
=if (isblank(a2), if(isblank(a1), b1, a1), a2)
this says if A2 is blank, then see if A1 is blank. If a1 is blank then show value from b1 else show value of a1. In case A2 is not blank then show value from A2