English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I had a list of items in Excel, and then I decided to split them up into five columns. I simply moved them over and now I have spaces inbetween items. Is there a way to easily consolidate the items, as in removing the spaces, without moving each item up to the top?

2006-10-06 04:45:39 · 10 answers · asked by beethovens_sixth 3 in Computers & Internet Software

I'm talking about consolidating individual cells. I want to keep the columns.

x xx
x x x
xx x

needs to become
xxxxx
xx xx

2006-10-06 04:51:02 · update #1

I'm talking about a lot of cells. I don't want to have to do something to each cell. Is there a button or something to remove all spaces in a list?

2006-10-06 04:52:13 · update #2

10 answers

You have two ways of doing this:

a) If you dont mind your data loosing its order then you can select the individual columns and from the 'Data' menu select sort - all empty cells would be shifted to the bottom

b) Select ALL your columns and from the 'Data' menu select 'Filter' then 'AutoFilter'. Excel will insert drop-arrows in row 1. Click each drop-arrow in succession, select '(NonBlanks)' and all your empty cells would be hidden. Copy the whole column and paste to a new sheet (this would only paste visible cells). Re-Click same drop-arrow and select '(All)' to show all again for that column - Repeat for each subsequent column.

2006-10-06 04:58:33 · answer #1 · answered by Norman 4 · 2 0

Remove Empty Cells Excel

2016-10-06 06:52:05 · answer #2 · answered by ? 4 · 0 0

Just to elaborate on the last post. To use find and replace in this you select the cells you want to edit the hit Edit and from the dropdown select Replace. In the Find What box simply enter a single space. In the Replace With box just leave it blank. That will pull out the spaces.

If you are trying to get the info from two different cell into one you can combine them by using the & for example =a1&b1 will put the contents of those two cells together - concatenate.

2006-10-06 17:35:28 · answer #3 · answered by sdh0407 5 · 0 1

Click Data, Sort, and sort the column you want to remove items on. This will group all your cells with values together and push all the empty cells to the bottom. I think this is what you wanted :)

2006-10-06 04:51:04 · answer #4 · answered by Christie B 1 · 1 0

Not sure exactly what you are looking for, but I have a couple of ideas.

1) If you are trying to remove all the spaces (inside cells) use Find and Replace to replace all spaces with nothing.

2) The TRIM function can be used to remove all spaces except a since space between words/characters.

2006-10-06 07:06:03 · answer #5 · answered by O Caçador 6 · 0 1

by sorting the column you can delete the cells

or

by using filter you can remove the cells

2006-10-06 05:20:19 · answer #6 · answered by vgk 1 · 1 0

right click on the top of the columns (where it says A, B) and select DELETE.

2006-10-06 04:46:59 · answer #7 · answered by klumzy 3 · 0 1

press the right mouse button over the colum and then go to delete and it will delete the whole column hope thats what you wanted

2016-03-27 05:29:49 · answer #8 · answered by Anonymous · 0 0

right click on the cell and click delete

2006-10-06 04:49:55 · answer #9 · answered by Rahul 1 · 0 1

thats too easier than which i think thanks a lot

2014-08-10 18:36:11 · answer #10 · answered by Anonymous · 0 0

fedest.com, questions and answers