Combining numbers in a column into one cell

**labogola** · 01-14-2014, 05:38 AM

Say I have a column of numbers. I'd like to be able to string them together in the following format: number1|number2|number3....

connect.xlsx

Any ideas?

**Pepe Le Mokko** · 01-14-2014, 06:16 AM

Try the CONCATENATE function or =A1&A2&A3....

EDIT forgot part of the request ;
Enter the | in a cell ( sayX1) and try =A1&X1&A2&X1&.....

**msexcelsiors** · 01-14-2014, 06:24 AM

=IF(ISBLANK(A1:A6)=FALSE,(A1:A6),"")
try this
array formula so ctr;+shift+enter

**labogola** · 01-22-2014, 06:14 AM

My solution. Let Say you have numbers sitting in columns A1-Ax.... in B1 set B1=A1, in B2, B2=B1&"|"A2... copy down.

Combining numbers in a column into one cell

LinkBack

Thread Tools

Rate This Thread

Display

Combining numbers in a column into one cell

Re: Combining numbers in a column into one cell

Re: Combining numbers in a column into one cell

Re: Combining numbers in a column into one cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting Excel 2007 to list the cell numbers of the top five ranked numbers in a column.

Combining row and column heading according to selected cell

[SOLVED] Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)

Combining multiple cells in a column into one cell on top of one another?

Combining Value of A Column to 1 Cell

Bookmarks

Bookmarks

Posting Permissions