Search : in
By :

Copy numbers of cell values in a single row

Last answer on Jul 17, 2009 5:42:00 am BST Ishi, on Jul 16, 2009 9:35:54 am BST 
 Report this message to moderators

Hello,

I have unit numbers in multiple rows which is captured from a pivot table from another sheet. I need to consolidate all the cell values from all the rows to one row as a running text.

Can someone help please.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « copy numbers of cell values in a single row » in :
Keyboard /Mouse Tips for Excel ShowKeyboard /Mouse Tips for Excel Intro Other Shortcuts Intro Excel tutorials give hints that make the difference between a needy use and flexibility. Here are some examples: Copy the highlight to the clipboard: [Ctrl + Ins] Paste...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...

1

 Excelguru, on Jul 17, 2009 5:42:00 am BST

Hello Ishi

if you hve data in A1, A2 etc then add the following formula in B2 =B1+A1 In the last cell you will get the desired value Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

Reply to Excelguru