Related:

- Find and replace blank cells in excel
- Excel vba replace blank cells with text - Best answers
- An example of a cell is a blank cell - Best answers
- How to ignore blank cells in excel ✓ - Forum - Excel
- Select non blank cells in excel ✓ - Forum - 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 go to next blank cell in column vba - How-To - Excel

## 4 replies

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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

weglik

Just press: ctrl+H (find and replace)

in find what: hold down the Alt key and type 0020

replace with whatever you need.

Hope it helps.

in find what: hold down the Alt key and type 0020

replace with whatever you need.

Hope it helps.

sjameen

- Posts
- 1
- Registration date
- Sunday June 20, 2010
- Status
- Member
- Last seen
- August 1, 2010

the above answer is also fine I have another formula if wish u can use this as well same result

=if(a2="",b1,a2)

=if(a2="",b1,a2)

Gregory

Thank you, it worked, but with isblank function rather than with " ". The trick is to create an empty column near to the desired column and then to copy the contents of the desired column into it. Then I wrote the formula =if(isblank(G15);H14;G15). Then you have to do some manual work in order to keep the existing formatting. You select the cell with the newly created formula and right-drag it down and the end select "Without formatting" In this case if you have some formatting in the original colum you will keep it. Now I have another question. In the adjucent to the newly filled column there is another one containing some distinctive information for each record in the newly created column (it is a number) Unfortunately in some places it is mixed with additional letter which turnes numbers into text.I probably need to use D(max) function to extract.the biggest number but I do not know how to select the biggest nubmers with the letters present. Please help if you know.

Sur Esh

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!

tstobb

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

How can I get this to work if I want certain conditions to be met? For example, my blanks are in column J and if cell J3 has the 1st blank, I only want the blanks filled in if the data in cell B3 and B2 are equal as well as the data in cells E3 and E2

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