onetuff_z - - Latest reply:
tstobb

- Posts
- 1
- Registration date
- Tuesday April 14, 2015
- Last seen
- April 14, 2015

Related:

- Excel find and replace blank cells
- Excel, use find and replace in a macro to fill blank cells - Best answers
- Find and replace blank cells in excel - How-To - Excel
- Select blank cells in excel mac - How-To - Excel
- Excel vb find blank cells replace with calc ✓ - Forum - Programming
- Excel - A Macro to copy and paste data in next blank cell - How-To - Excel
- Excel - Applying a formula for a range of cells - How-To - Excel

Best answer

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- January 6, 2016

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

A few words of thanks would be greatly appreciated. Add comment

has helped 2483 users this month

Hey! you can try the following steps...

Assume you're having the data in column "A".

* Select the full data range.

* Press "F5" or "Ctrl + G". The "Go To" window opens.

* Click "Special" button at the bottom left.

* Then click "blanks" & give "Enter".

* Without disturbing any cell, write "=" & press the up arrow.

* Then give "Ctrl + Enter"

So the shortcut after selecting the range will be as follows...

"F5" + "Alt S" + "K" + "Enter" + "= ?" + "Ctrl + Enter"

Lemme know if this works!

Assume you're having the data in column "A".

* Select the full data range.

* Press "F5" or "Ctrl + G". The "Go To" window opens.

* Click "Special" button at the bottom left.

* Then click "blanks" & give "Enter".

* Without disturbing any cell, write "=" & press the up arrow.

* Then give "Ctrl + Enter"

So the shortcut after selecting the range will be as follows...

"F5" + "Alt S" + "K" + "Enter" + "= ?" + "Ctrl + Enter"

Lemme know if this works!

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

=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