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
|
|||
|
|||
Replacing carriage returns with a comma
Hi
I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... Help TIA -- Sue Compelling |
#2
|
|||
|
|||
Replacing carriage returns with a comma
With Activecell
.Value = Replace(.Value, Chr(10),",") End With -- __________________________________ HTH Bob "Sue Compelling" wrote in message ... Hi I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... Help TIA -- Sue Compelling |
#3
|
|||
|
|||
Replacing carriage returns with a comma
hi
see this site... http://en.allexperts.com/q/Excel-105...-returns-1.htm regards FSt1 "Sue Compelling" wrote: Hi I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... Help TIA -- Sue Compelling |
#4
|
|||
|
|||
Replacing carriage returns with a comma
Thanks FSt1 for the quick response - I also kept searching and discovered the
very simple Find CTL J Replace , Replace ALL Brilliant -- Sue Compelling "FSt1" wrote: hi see this site... http://en.allexperts.com/q/Excel-105...-returns-1.htm regards FSt1 "Sue Compelling" wrote: Hi I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... Help TIA -- Sue Compelling |
#5
|
|||
|
|||
Replacing carriage returns with a comma
Sue Compelling wrote:
Hi I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... This might work for you =SUBSTITUTE(A1,CHAR(10),",") |
#6
|
|||
|
|||
Replacing carriage returns with a comma
thanks sue the ctrl J worked for me. the Alt 013 didnt - saved me a couple of
couple of delete down arrow, delete down arrow, delete down arrow. "Sue Compelling" wrote: Thanks FSt1 for the quick response - I also kept searching and discovered the very simple Find CTL J Replace , Replace ALL Brilliant -- Sue Compelling "FSt1" wrote: hi see this site... http://en.allexperts.com/q/Excel-105...-returns-1.htm regards FSt1 "Sue Compelling" wrote: Hi I have an address cell which has data with multiple lines - eg: School of Science Medical University and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns ... Help TIA -- Sue Compelling |
Thread Tools | |
Display Modes | |
|
|