Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard breaks in text to soft breaks in Excel
Hi, Am importing data into Excel from raw text files. Text files contai 'hard' line breaks, but I need all data to be in a single cell wit 'soft' line breaks... ie alt+Enter... Is there any easy way to do this? Please help?!!!!! :- -- tbaile ----------------------------------------------------------------------- tbailey's Profile: http://www.excelforum.com/member.php...fo&userid=2556 View this thread: http://www.excelforum.com/showthread.php?threadid=38999 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard breaks in text to soft breaks in Excel
Alt+enter isn't a softbreak. It is a hard break. As long a workwrap is
applied the text will break at the point as a minimum. -- Regards, Tom Ogilvy "tbailey" wrote in message ... Hi, Am importing data into Excel from raw text files. Text files contain 'hard' line breaks, but I need all data to be in a single cell with 'soft' line breaks... ie alt+Enter... Is there any easy way to do this? Please help?!!!!! :-) -- tbailey ------------------------------------------------------------------------ tbailey's Profile: http://www.excelforum.com/member.php...o&userid=25566 View this thread: http://www.excelforum.com/showthread...hreadid=389990 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard breaks in text to soft breaks in Excel
If you really meant soft breaks instead of hard breaks then look at
Replace() eg strContent = Replace(strContent, chr(10),"") strContent = Replace(strContent, chr(13),"") Tim. "tbailey" wrote in message ... Hi, Am importing data into Excel from raw text files. Text files contain 'hard' line breaks, but I need all data to be in a single cell with 'soft' line breaks... ie alt+Enter... Is there any easy way to do this? Please help?!!!!! :-) -- tbailey ------------------------------------------------------------------------ tbailey's Profile: http://www.excelforum.com/member.php...o&userid=25566 View this thread: http://www.excelforum.com/showthread...hreadid=389990 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Word cell containing line breaks (soft returns) to Excel | Excel Discussion (Misc queries) | |||
Text to Columns with Line Breaks. | Excel Discussion (Misc queries) | |||
Formating text columns layout with page breaks in Excel 97 | New Users to Excel | |||
Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
removing hard breaks from comments or active cells | Excel Programming |