Find and replace with cell reference

[tadrim]

Hi All!

I'm trying to do a find and replace but I would like to replace the contents with a Cell value, there are around 500 cells that need this doing so i'm trying to think of a way to do it using the cell value as a variable

Basically one of the example are below:

=IF(ISBLANK(IDdata!$B$3),"","here")

I'm wanting to change the "here" with (IDdata!$B$3) so the full string to look like:

=IF(ISBLANK(IDdata!$B$3),"",(IDdata!$B$3)

Any help would be much appreciated!!

Thanks!

 

[Rick Rothstein]

You have one parenthesis too many, try it like this...

=IF(ISBLANK(IDdata!$B$3),"",IDdata!$B$3)

 

[tadrim]

You have one parenthesis too many, try it like this...

=IF(ISBLANK(IDdata!$B$3),"",IDdata!$B$3)

Hi There!

Thanks for that, I dont suppose you would know how to do a find and replace to replace all the "heres" with the cell references that are listed earlier within the cell?

Thanks

 

[Rick Rothstein]

Thanks for that, I dont suppose you would know how to do a find and replace to replace all the "heres" with the cell references that are listed earlier within the cell?

Unless I am misunderstanding what you want as a final result, I would think you should use this formula and copy it down to the end of your data...

=IF(ISBLANK(IDdata!B3),"",IDdata!B3)

The $ signs were making the cell references "absolute"... removing them makes the cell references "relative".

 

[tadrim]

Unless I am misunderstanding what you want as a final result, I would think you should use this formula and copy it down to the end of your data...

=IF(ISBLANK(IDdata!B3),"",IDdata!B3)

The $ signs were making the cell references "absolute"... removing them makes the cell references "relative".

Hi There!

Thanks, the problem is that i have around 500 records each are fortmatted so there are around 3 spaces between each row, there is also multiple references that also need incrementing i.e

=IF(ISBLANK(IDdata!$F$2),"","here"
=IF(ISBLANK(IDdata!$C$2),"","here"

etc hope that makes a little more sense!

Thanks!