Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating some text in cells?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating some text in cells?
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. -- Regards, Tom Ogilvy "drewdrew" wrote in message ... Hey guys I have a spreadsheet that contains about 4000 unique products/skus each with its own description. The problem is the data I received in the description column was not formated correctly. Currenty the data in the cells look like this: '*Features a smaller handle spread with a comfortable, ergonomically designed handle. *Ideal for the hard to handle smaller connectors, such as fiber optic 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, ergonomically designed handle.*Ideal for the hard to handle smaller connectors, such as fiber optic connectors and open barrel contacts. Die sets are easily interchangeable with a screwdriver. Is their a way I can format this data in excel so it looks merged together?? -- drewdrew ------------------------------------------------------------------------ drewdrew's Profile: http://www.excelforum.com/member.php...o&userid=16560 View this thread: http://www.excelforum.com/showthread...hreadid=314196 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Formating text in cells | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
formating text cells | Excel Discussion (Misc queries) |