Excel find and replace that contains carriage returns

Hi guys,

In my cells I have the following data:

Key Features:
 - Setting 1
 - Setting 2
 - Setting 3
 - Setting 4

I need each cell to just contain:

<br />Setting 1
<br />Setting 2
<br />Setting 3
<br />Setting 4


There are carriage returns between the lines.

Cheers,
Dean
deanlee17Asked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Ok, maybe it's easier to do it this way....

in B2 add formula:

=SUBSTITUTE(A2,CHAR(10),"<br/>")

copied down.

then you can copy this column and paste special >> values over the original column.  Then delete the formula column.
0
 
NBVCCommented:
I am not sure I understand the request.

Are all of these in one cell?

 - Setting 1
 - Setting 2
 - Setting 3
 - Setting 4

are you just looking to replace the - with <br/>?
0
 
deanlee17Author Commented:
Sorry, Yes its all in the same cell.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
NBVCCommented:
So you tried replacing the dash with <br/>?
0
 
deanlee17Author Commented:
Some of the settings contain a dash..

- this is the settting 32 - 31
0
 
NBVCCommented:
Maybe then replace this:

- S

with

<br/>S

ie. include the S
0
 
deanlee17Author Commented:
Ok sorry I realise I wasn't clear, here is a real copy of the data:

Key Features
- Heat Settings - Variable
- Control - Manual control
- Flame Control Options - Can be used independent of heat
- Thermostat - Yes
- Spacer Frame - Included allowing fire to be fitted flat to wall
- Flame Effect - Glowing log bed
- Colour Finish - Available in chrome and black
- Fuel Bed - Log
- Max Output - 2.0 kw

So I kinda need to search for '<carriage return> - '
0
 
NBVCCommented:
Ok,    In the FIND What field:  hold down the ALT key, then type the carriage return code (e.g. 010) using the number pad on your keyboard.
0
 
deanlee17Author Commented:
Ok I press tab and cursor stops flashing, type '0' and I get the error tone, then it types '10'
0
 
NBVCCommented:
You need to hold the ALT key down and while holding it down type 010.  You should see what appears to be a space.
0
 
deanlee17Author Commented:
Nope, doesn't work for me. Using office 2010 professional plus, if that helps.
0
 
NBVCCommented:
Can you post a workbook showing a sampling with the carriage returns in place.
0
 
deanlee17Author Commented:
Yes sure, see attached
sheet.xlsx
0
 
deanlee17Author Commented:
Perfect, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.