If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I eliminate carriage returns in a cell
I have a data base of names and addresses with the address in one field with
the seperator being a carriage return. I would like to chane that so I can use the text to columns function in Excel |
#2
|
|||
|
|||
How do I eliminate carriage returns in a cell
In A1, I entered "hot", pressed ALT+ENTER, "dog"
A1 displayed the text with one word under the other In B1, I use =SUBSTITUTE(A1,CHAR(10)," ") and B1 displayed the two words with a space between them. I used Copy followed by Paste Special-Values to get this as text Now I can use Text to Columns Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Squirrelwatcher" wrote in message ... I have a data base of names and addresses with the address in one field with the seperator being a carriage return. I would like to chane that so I can use the text to columns function in Excel |
#3
|
|||
|
|||
How do I eliminate carriage returns in a cell
Thanks Bernard for your help. Sorry this question appeared in Charts and the
delay in saying thanks. It took me a while to find the reply button "Bernard Liengme" wrote: In A1, I entered "hot", pressed ALT+ENTER, "dog" A1 displayed the text with one word under the other In B1, I use =SUBSTITUTE(A1,CHAR(10)," ") and B1 displayed the two words with a space between them. I used Copy followed by Paste Special-Values to get this as text Now I can use Text to Columns Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Squirrelwatcher" wrote in message ... I have a data base of names and addresses with the address in one field with the seperator being a carriage return. I would like to chane that so I can use the text to columns function in Excel |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VLOOKUP using a cell calculated with NOW returns Error | Chris Berding | Worksheet Functions | 2 | August 21st, 2005 03:22 AM |
Removing Carriage Returns from Memo Fields | [email protected] | Using Forms | 1 | June 9th, 2005 12:38 AM |
up to 7 functions? | ALex | Worksheet Functions | 10 | April 12th, 2005 06:42 PM |
Carriage Returns in my data as a box | ChuckW | Setting Up & Running Reports | 7 | March 15th, 2005 02:32 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |