How can one copy a block of active cells using "=" and retain "true blanks"?

[Sunny54321]

Hi,

I am trying to create a "template" by having one sheet capture external "raw data" of varying length and information position (I cut and paste it in). From there, I have another sheet that tries to bring forward the relevant block of cells from the "RAW DATA".

I need tight space and small cell size such that certain lines of TEXT can "spill over" into the next empty cell. But when I use this method of filling each cell using an "=" from the reference columns in the "raw data", those "blank cells" become filled as if they are no longer "blank".

Is there a way to use the "=" sign technique of capturing varying data columns and retaining blank cells as "purely empty"?

Any suggestions are welcome.

Thanks,
Sunny

 

[JoeMo]

A cell containing a formula cannot be "purely empty". Can you wrap text where spill over is precluded by your formulas in adjacent cells?