| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carriage returns - how to get rid of them (again) | Excel Discussion (Misc queries) | |||
| Formula for Carriage Returns | Excel Discussion (Misc queries) | |||
| Carriage returns in the formula bar? | Excel Worksheet Functions | |||
| Replacing commas with carriage return | Excel Worksheet Functions | |||
| Carriage returns | Excel Discussion (Misc queries) | |||
Linear Mode
