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
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
ASKER
Sorry, Yes its all in the same cell.
So you tried replacing the dash with <br/>?
ASKER
Some of the settings contain a dash..
- this is the settting 32 - 31
- this is the settting 32 - 31
Maybe then replace this:
- S
with
<br/>S
ie. include the S
- S
with
<br/>S
ie. include the S
ASKER
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> - '
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.
ASKER
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.
ASKER
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.
ASKER
Yes sure, see attached
sheet.xlsx
sheet.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, thanks.
Are all of these in one cell?
- Setting 1
- Setting 2
- Setting 3
- Setting 4
are you just looking to replace the - with <br/>?