Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 1lack numbers in a excell sheet in column A, the same thing I would
like to copy in a notepad but I want numbers should come in horizontal i.e in row. please help me out. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1. select the cells in the column and copy them
2. in an un-used area of the worksheet: Edit PasteSpecial Transpose 3. copy the transposed data and paste in NotePad -- Gary''s Student - gsnu200813 "Enni" wrote: I have 1lack numbers in a excell sheet in column A, the same thing I would like to copy in a notepad but I want numbers should come in horizontal i.e in row. please help me out. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I think i lack means 100000 (in Indian English) .
Isn't it Enni. well, if this is what you meant then sorry, transpose will not work even in excel 2007. I'll give you a work around. Copy the complete the column and paste in in notepad now copy the data in notepad and paste it in one cell in excel (double click a cell or select the cell and press "f2" and then paste) now use the formula =SUBSTITUTE(A1,CHAR(13)," ") you have the complete numbers in one row delimited by a space. now you can copy the data to notepad. Finally, pls reply i was in the right direction or my answer went haywire. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Gary''s Student" wrote: 1. select the cells in the column and copy them 2. in an un-used area of the worksheet: Edit PasteSpecial Transpose 3. copy the transposed data and paste in NotePad -- Gary''s Student - gsnu200813 "Enni" wrote: I have 1lack numbers in a excell sheet in column A, the same thing I would like to copy in a notepad but I want numbers should come in horizontal i.e in row. please help me out. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please use this formula instead
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(10)," "),CHAR(13),"") you can use any other character instead of space (it is just after char(10) in the formula) -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Satti Charvak" wrote: I think i lack means 100000 (in Indian English) . Isn't it Enni. well, if this is what you meant then sorry, transpose will not work even in excel 2007. I'll give you a work around. Copy the complete the column and paste in in notepad now copy the data in notepad and paste it in one cell in excel (double click a cell or select the cell and press "f2" and then paste) now use the formula =SUBSTITUTE(A1,CHAR(13)," ") you have the complete numbers in one row delimited by a space. now you can copy the data to notepad. Finally, pls reply i was in the right direction or my answer went haywire. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Gary''s Student" wrote: 1. select the cells in the column and copy them 2. in an un-used area of the worksheet: Edit PasteSpecial Transpose 3. copy the transposed data and paste in NotePad -- Gary''s Student - gsnu200813 "Enni" wrote: I have 1lack numbers in a excell sheet in column A, the same thing I would like to copy in a notepad but I want numbers should come in horizontal i.e in row. please help me out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Multiple Column Values into 1 column | Excel Worksheet Functions | |||
convert column to row | Excel Discussion (Misc queries) | |||
Convert column to row | Excel Worksheet Functions | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) |