• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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
0
deanlee17
Asked:
deanlee17
  • 7
  • 7
1 Solution
 
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
 
NBVCCommented:
So you tried replacing the dash with <br/>?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
NBVCCommented:
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
 
deanlee17Author Commented:
Perfect, thanks.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now