Jan 11 2021 06:51 AM
Hi
I want to move highlighted cells to new column without overwriting formulas in blank cells so column L to G with the spaces. Tried copy and paste special but doesn't work.
Many thanks
Gary
Jan 11 2021 07:02 AM
@Gary05P When you copy and paste special, you should see an option "Skip blanks".
Picture taken on a Mac, but it's similar on Windows.
Jan 11 2021 07:09 AM
@Riny_van_Eekelen Thanks for the quick reply. When I do that this is the result:-
I would like to move from L to G to look the same
Jan 11 2021 07:23 AM
@Gary05P You need to copy the whole range from L and paste (special) it to L1, with Skip blanks.
Jan 11 2021 07:29 AM
@Riny_van_Eekelen It then overwrites the formulas that are already there.
Jan 11 2021 07:33 AM
@Gary05P But then the "gaps" in column L aren't blank. Perhaps I misunderstood.
Jan 11 2021 07:38 AM
@Gary05P Can you upload your file (or part of it)? Remove any confidential information.
Jan 11 2021 07:50 AM
@Riny_van_Eekelen Thanks for your help with this
Jan 11 2021 08:14 AM
Solution@Gary05P Okay! Column L is not clean. Many of the "blank" cells aren't really blank. Shown in column M. That's why past special/skip blanks doesn't work.
Copied the original column L to column O and applied Data / Text-to-column to get rid of the "hidden characters". Then I could copy O to G (Paste special / Values / Skip blanks).
See if it works for you.
Jan 12 2021 03:11 AM
Y@Riny_van_Eekelen Yes that worked, I can now apply that to my other worksheets. Thank you very much
Jan 11 2021 08:14 AM
Solution@Gary05P Okay! Column L is not clean. Many of the "blank" cells aren't really blank. Shown in column M. That's why past special/skip blanks doesn't work.
Copied the original column L to column O and applied Data / Text-to-column to get rid of the "hidden characters". Then I could copy O to G (Paste special / Values / Skip blanks).
See if it works for you.