Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in a c
I have data that has been downloaded from a tool and sometimes comments are
listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in a c
If these are carriage returns you should be able to remove them using DataText
to Columns. Select the cells...make sure you have some blank collumns to right of cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next. Are the cells broken up? If so hit Finish. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt wrote: I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in a c
I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j).
Doesn't change your reply, though. Gord Dibben wrote: If these are carriage returns you should be able to remove them using DataText to Columns. Select the cells...make sure you have some blank collumns to right of cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next. Are the cells broken up? If so hit Finish. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt wrote: I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in a c
CR is my generic term for anything that resembles a line feed or whatever.
Maybe they should be hard returns and soft returns? It's all too confusing anymore. Gord On Wed, 06 Jun 2007 16:39:28 -0500, Dave Peterson wrote: I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j). Doesn't change your reply, though. Gord Dibben wrote: If these are carriage returns you should be able to remove them using DataText to Columns. Select the cells...make sure you have some blank collumns to right of cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next. Are the cells broken up? If so hit Finish. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt wrote: I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in
Thanks for this. I was also looking for the same thing. I do have a
question, what are CRs and LFs? "Gord Dibben" wrote: CR is my generic term for anything that resembles a line feed or whatever. Maybe they should be hard returns and soft returns? It's all too confusing anymore. Gord On Wed, 06 Jun 2007 16:39:28 -0500, Dave Peterson wrote: I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j). Doesn't change your reply, though. Gord Dibben wrote: If these are carriage returns you should be able to remove them using DataText to Columns. Select the cells...make sure you have some blank collumns to right of cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next. Are the cells broken up? If so hit Finish. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt wrote: I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help with removing "enters" that are separating data in
CR......Carriage Return
LF.......Line Feed Using Alt + Enter you can place linefeeds into a cell. As noted by Dave, these are not technically carriage returns but anything that returns the cursor or carriage to left side of the next line can be called a carriage return IMO Gord On Fri, 15 Jun 2007 13:21:00 -0700, Gilbert wrote: Thanks for this. I was also looking for the same thing. I do have a question, what are CRs and LFs? "Gord Dibben" wrote: CR is my generic term for anything that resembles a line feed or whatever. Maybe they should be hard returns and soft returns? It's all too confusing anymore. Gord On Wed, 06 Jun 2007 16:39:28 -0500, Dave Peterson wrote: I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j). Doesn't change your reply, though. Gord Dibben wrote: If these are carriage returns you should be able to remove them using DataText to Columns. Select the cells...make sure you have some blank collumns to right of cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next. Are the cells broken up? If so hit Finish. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt wrote: I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example : *test *test2 *test 3 I hit the enter key after each line, but in excel it keeps all 3 lines in one cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Removing digits after decimal in "text" numbers | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |