Link to home
Start Free TrialLog in
Avatar of deanlee17
deanlee17

asked on

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
Avatar of NBVC
NBVC
Flag of Canada image

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/>?
Avatar of deanlee17
deanlee17

ASKER

Sorry, Yes its all in the same cell.
So you tried replacing the dash with <br/>?
Some of the settings contain a dash..

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

- S

with

<br/>S

ie. include the S
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> - '
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.
Ok I press tab and cursor stops flashing, type '0' and I get the error tone, then it types '10'
You need to hold the ALT key down and while holding it down type 010.  You should see what appears to be a space.
Nope, doesn't work for me. Using office 2010 professional plus, if that helps.
Can you post a workbook showing a sampling with the carriage returns in place.
Yes sure, see attached
sheet.xlsx
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect, thanks.