How delete only emty cell in tab?

[Zelon23]

Hi, can I delete only empty cell without delet other data in tab like this:

1	Globus	4,27			5,22				6,22			7,22			8,17	8,37		9,07			10,07	10,37		11,07	11,37		12,07	12,37		13,07	13,37		14,17		14,47	15,17	15,42	16,07	16,37	17,17		18,12			19,02		20,02	20,57			22,12
10	PZ, N.Spoř.			5,16								7,28																		13,18																			21,18
13	Otvice		4,54		5,26			6,08		6,51	7,08				8,08	8,48			9,23	9,58				11,13		11,54		12,24		13,09	13,32			14,21	14,43	15,21	15,56	16,24	16,48	17,09	17,40	17,57	18,25		19,09	19,57			21,23		22,35
31	Vodní		4,50				5,45	6,10			7,10			7,45		8,30		9,10						11,10				12,30		13,10		13,50		14,30		15,15	15,55		16,40	17,20
33	poliklinika	4,30		5,10	5,25	5,35	5,55	6,15	6,35	6,55	7,15	7,25	7,35	7,55	8,18	8,35	8,55	9,15	9,35	9,55	10,15	10,35	10,55	11,15	11,35	11,50	12,15	12,35	12,50	13,15	13,35	13,55	14,15	14,36	14,55	15,35	15,55	16,15	16,35	17,15	17,45		18,10	18,39	19,10	19,40	20,18	20,45	21,15	21,40	22,25
34	Ch,aut.nádr			5,14				6,07	6,28				7,31		8,10						10,05		10,45		11,22		12,06			13,00	13,28		14,08		14,49	15,27		16,08	16,47		17,33		18,25	18,47			20,02		21,25
35	železárny		5,03	5,17		5,30			6,22	6,46	7,05			7,47	8,04			9,05						11,05						13,05	13,23		14,03	14,26	15,05		15,45	16,02	16,25	17,05	17,27			18,58					21,10

<colgroup><col><col><col><col><col span="5"><col span="43"></colgroup><tbody>
</tbody>

<colgroup><col><col><col><col><col><col span="5"><col span="36"></colgroup><tbody>
</tbody>

 

[Smitty]

Welcome to the Board!

You'll need to be a bit more specific. Why would you need to delete empty cells? Do you want to shift the data to the left so that you don't have any blanks between values on each row?

 

[Rick Rothstein]

I am guessing that you want to move existing values to the left (rather than upward) to fill in the cells that are deleted. Try this... select all your rows of data... press the F5 key... click the Special button... select the Blanks option button and then click the OK button... find the Delete button on the Home tab and click its downward pointing triangle... select "Delete Cells..." from the list... select the "Shift cells left" option button and click the OK button.

 

[Zelon23]

Thanks a lot, it work perfectly You saved me a lto of time