Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a document to one column
I have a document with a list of names. All names are separated by a space. How do i convert to a single column list in excel? -- EyeGorePS ------------------------------------------------------------------------ EyeGorePS's Profile: http://www.excelforum.com/member.php...o&userid=35744 View this thread: http://www.excelforum.com/showthread...hreadid=555248 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a document to one column
DataText to ColumnsSpace delimited and Finish?
From your description, it is hard to figure out out exactly what you need. Are the space-separated names in one cell? What means "single column list" if they are already in one column? Maybe a small example of your data would help. Gord Dibben MS Excel MVP On Sat, 24 Jun 2006 11:28:14 -0500, EyeGorePS wrote: I have a document with a list of names. All names are separated by a space. How do i convert to a single column list in excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a document to one column
The data is in a text file and has not been imported or opened in excel. The data is: john414 mary556 tim238 etc. I would like to place the document into excel so that all the names a john414 mary556 tim238 I am brand new to excel and do appreciate any help. Thank you! -- EyeGorePS ------------------------------------------------------------------------ EyeGorePS's Profile: http://www.excelforum.com/member.php...o&userid=35744 View this thread: http://www.excelforum.com/showthread...hreadid=555248 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a document to one column
"EyeGorePS" wrote
in message ... The data is in a text file and has not been imported or opened in excel. The data is: john414 mary556 tim238 etc. I would like to place the document into excel so that all the names a john414 mary556 tim238 I am brand new to excel and do appreciate any help. Gord's Data/ Text to Columns recommendation will produce a row of data. Select that data, Cut, then Paste Special/ Transpose to give your column. Another option is to use an editor on your text file, and replace space by paragraph mark. -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a document to one column
"Etc." always bothers me.
Your example shows 3 space-separated names plus and indeterminte number of names designated by "etc." Could there be more than 256 names in a cell? Text to columns would not work in that case due to column limitations and you would have to do something with the text before inporting. If you do get them into rows, you can move them into one continuous column using this macro. Sub One_Column() Dim cell As Range, i As Integer i = 1 For Each cell In Selection Range("d1").Cells(i) = cell i = i + 1 Next End Sub Note: I used D1 as start cell only because you used 3 names. I assume you would have those names in cols A,B,C Gord On Sat, 24 Jun 2006 11:52:41 -0500, EyeGorePS wrote: The data is in a text file and has not been imported or opened in excel. The data is: john414 mary556 tim238 etc. I would like to place the document into excel so that all the names a john414 mary556 tim238 I am brand new to excel and do appreciate any help. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |