| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing the "ALT+ENTER"?
How can I remove the "ALT+ENTER - line break" from a list of cells ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
=SUBSTITUTE(A1,CHAR(10),"")
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Thank you Bob.
The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Not for me it doesn't, are you sure it is Alt-Enter?
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Maybe it's not an alt-enter.
I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Thanks.
Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
What did you find from Chip's addin?
salvo00 wrote: Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Do a =CODE(MID(A1,4,1))
to get the character code (change 4 to where it actually is) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
This small cube is also presented as a vertical line ( a bold capital I).
"Dave Peterson" wrote: What did you find from Chip's addin? salvo00 wrote: Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Was was the code for that character--using Chip's addin will tell you.
salvo00 wrote: This small cube is also presented as a vertical line ( a bold capital I). "Dave Peterson" wrote: What did you find from Chip's addin? salvo00 wrote: Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
Maybe a "pipe" from pipe-delimited.
Code 0124 Gord Dibben MS Excel MVP On Tue, 14 Nov 2006 08:57:02 -0800, salvo00 wrote: This small cube is also presented as a vertical line ( a bold capital I). "Dave Peterson" wrote: What did you find from Chip's addin? salvo00 wrote: Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
I found out that there are several characters codes: 10, 13, 32
Doing =SUBSTITUTE with all characters (i have found) solves the problem. I am not sure yet but I am testing it .. Thanks very much for all your help. "Bob Phillips" wrote: Do a =CODE(MID(A1,4,1)) to get the character code (change 4 to where it actually is) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing the "ALT+ENTER"?
32 is a space isn't it, probably not a good idea to remove that.
Also, in case you don't know, you can embed the subs =SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),"" ) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... I found out that there are several characters codes: 10, 13, 32 Doing =SUBSTITUTE with all characters (i have found) solves the problem. I am not sure yet but I am testing it .. Thanks very much for all your help. "Bob Phillips" wrote: Do a =CODE(MID(A1,4,1)) to get the character code (change 4 to where it actually is) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... Thanks. Unfortunately it is not an alt+enter. After testing both char(10 or 13) I always get at the end of the phrase a small square (cube). The cells have been exported from the MS-Access. In each cell there were 3,4 phrases. I'm trying to get a non-formatted text (no line breaks) but it seems impossible. Salvo "Dave Peterson" wrote: Maybe it's not an alt-enter. I'd try this next: =SUBSTITUTE(A1,CHAR(13),"") If that doesn't work... Chip Pearson has a very nice addin that will help determine what that character(s) is: http://www.cpearson.com/excel/CellView.htm Then you can use that info in the correct formula. salvo00 wrote: Thank you Bob. The formula replaces the line-break with a small square. I don't want that symbol. I just want a space and all the text in 1 line. Is there a solution? Salvo "Bob Phillips" wrote: =SUBSTITUTE(A1,CHAR(10),"") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "salvo00" wrote in message ... How can I remove the "ALT+ENTER - line break" from a list of cells ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing characters | Excel Discussion (Misc queries) | |||
| Clear Cell Without Removing Formula | Excel Worksheet Functions | |||
| Removing grids | Excel Discussion (Misc queries) | |||
| Removing trailing spaces from cells ? | Excel Worksheet Functions | |||
| How do I stop excel removing zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
