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?

--
drewdre
-----------------------------------------------------------------------
drewdrew's Profile: http://www.excelforum.com/member.php...fo&userid=1656
View this thread: http://www.excelforum.com/showthread.php?threadid=31419