Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bing
 
Posts: n/a
Default Why text to columns is not available when there is mulipule line .

When converting text to colums for cells have multiple line breakers, the
text wizard pulls only the text before the first line breaker when selecting
Delimited function? Is this a known issue? How would I correct it?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

I assume you mean you have a carriage return (alt + enter),
select delimited, click next, check other delimiter and hold down alt while
typing 010 on the numpad
click finish

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Bing" wrote in message
...
When converting text to colums for cells have multiple line breakers, the
text wizard pulls only the text before the first line breaker when
selecting
Delimited function? Is this a known issue? How would I correct it?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, using line wrap with text, some cells will appear as ##. RSCoyner Excel Discussion (Misc queries) 4 January 20th 05 12:21 AM
text from one column into multiple columns Jeff Brown Excel Discussion (Misc queries) 6 December 22nd 04 11:07 PM
Text import out of line? Krefty Excel Discussion (Misc queries) 3 December 21st 04 06:08 PM
Adding a text label to a line. Neil Charts and Charting in Excel 1 December 4th 04 09:41 PM
Forcing text onto new line in cell Doug Poll New Users to Excel 2 December 3rd 04 01:09 PM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"