Function

[jonathan_marcus]

Would really appreciate some help.

I need to replace (or populate) all cells that do not have a value within a range with a single fixed value.

For instance:

A1 = 5
B1 = 5
C1 = No value (Blank)
D1 = 10
E1 = No value (Blank)

I need a function (non-VBA) that identifies cells C1 and E1, and populates them with a fixed value (the value can be anything).

Any suggestions? Thanks in advance.

 

[Domenic]

How about using REPLACE...

1) Select your range of cells

2) Edit > Replace

Find what: leave blank

Replace with: (enter your value)

3) Click 'Replace All'

Hope this helps!

 

[jonathan_marcus]

Thanks.

Dont I feel like a jerk
Really appreciate it.