Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with formula
I was wondering if there was a way to copy data from one column to another without copying the blank cells? Here's an example: A B C D E F G H 1 . 2 3 . 4 5 . 6 The dots represent my data (every second cell) and I need to copy that to H column but one cell after another (ie H1, H2, H3...). Is there a way to do this? -- smanuel ------------------------------------------------------------------------ smanuel's Profile: http://www.excelforum.com/member.php...o&userid=16337 View this thread: http://www.excelforum.com/showthread...hreadid=277237 |
#2
|
|||
|
|||
Hi
if you select the range that you want to copy and then click on H1 and choose Edit / Paste Special and tick Skip Blanks you should get what you're after. Cheers JulieD "smanuel" wrote in message ... I was wondering if there was a way to copy data from one column to another without copying the blank cells? Here's an example: A B C D E F G H 1 . 2 3 . 4 5 . 6 The dots represent my data (every second cell) and I need to copy that to H column but one cell after another (ie H1, H2, H3...). Is there a way to do this? -- smanuel ------------------------------------------------------------------------ smanuel's Profile: http://www.excelforum.com/member.php...o&userid=16337 View this thread: http://www.excelforum.com/showthread...hreadid=277237 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |