Deleting all cells in row after blank space

[Stopwatch]

In short I was just wondering: is there a simple way to, for each row, move right and check if there's a blank cell and if so delete everything to the right of it? I've come to the conclusion it can't simply be done with a formula. Thanks!

[Joe Bushfield]

You could create a 'Twin' table that copies the corresponding cell based upon the value of the cell to the left;

=IF(A1="","",B1)

[berlan]

Maybe,

Please Login or Register  to view this content.

or,

Please Login or Register  to view this content.

where we check for all empty cells in Col.A and delete the cell to the right (in Col.B)

Is that something you can work with?

[walruseggman]

But I think OP wanted everything to the right in that row deleted. My approach:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Or Maybe:

Please Login or Register  to view this content.

[Stopwatch]

That worked perfectly John, thanks! Thanks to everyone else as well!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.