LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I separate wrap text in excel spreadsheet?

I work with mailing lists in Excel, and sometimes I run into wrapped text
that when I unwrap it, it results in line breaks (little boxes) within cells
that were wrapped.
What I'd like to know is whether there's a way to use that line break as a
delimiter
to separate the data (i.e. two address lines) into separate columns.
 
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
text wrap when saving spreadsheet as web page nadjahs9 Excel Discussion (Misc queries) 0 September 20th 07 05:46 PM
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
When I wrap text, excel hides the text display Vidyaji Excel Discussion (Misc queries) 4 March 12th 07 02:33 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
how do I wrap up the text to all comments in one spreadsheet? CQ Excel Discussion (Misc queries) 0 December 6th 05 09:16 PM


All times are GMT +1. The time now is 12:29 PM.

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"