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:
 Find and replace blank cells in excel
 An example of a cell is a blank cell  Best answers
 Excel vba replace blank cells with text  Best answers
 Excel vb find blank cells replace with calc ✓  Forum  Programming
 Excel index match ignore blank cells ✓  Forum  Excel
 Excel go to next blank cell in column vba  Guide
 Excel find next blank cell ✓  Forum  Programming
 Excel vba copy non blank cells in range ✓  Forum  Excel
4 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
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