Formating some text in cells?

[drewdrew]

Hey guys

I have a spreadsheet that contains about 4000 unique products/skus eac
with its own description. The problem is the data I received in th
description column was not formated correctly.

Currenty the data in the cells look like this:

'*Features a smaller handle spread with a comfortable, ergonomicall
designed handle.
*Ideal for the hard to handle smaller connectors, such as fiber opti
connectors and open barrel contacts.
*Die sets are easily interchangeable with a screwdriver.

but I want the data to look like this instead:

*Features a smaller handle spread with a comfortable, ergonomicall
designed handle.*Ideal for the hard to handle smaller connectors, suc
as fiber optic connectors and open barrel contacts. Die sets are easil
interchangeable with a screwdriver.


Is their a way I can format this data in excel so it looks merge
together?

 

[Tom Ogilvy]

in an adjacent column put in a formula like

=Substitute(C2,char(10)," ")

Then format that cell to word wrap.

Drag fill the formula down the column

select the column and copy, then select the original text column and do
Edit=>Paste Special and select Values.

This assumes the formula produces the desired outcome.

Try this on a copy of your data.