LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Automatic line break in cells

Hi

I know I can perform a manual line break in a cell by pressing ALT+ENTER,
but is there a way to do this automatically after a space or a specific
caracter?

I get a report generated from another software and column A lists different
tags. There can be up to 10 different tags within one cell and all thos tags
are separated by a comma.

How can I tell Excel to automatically insert a line break after evey commas
in the cells of column A?

Thanks
 
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
Cannot move an automatic page break financialsecretary Excel Discussion (Misc queries) 3 July 25th 07 05:06 PM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM
concantenatring 2 cells with with a line break dick Excel Discussion (Misc queries) 7 June 8th 06 06:27 AM
How do I get a line break when using a formula to combine cells TESA0_4 Excel Worksheet Functions 5 May 13th 06 03:15 PM
I need to print cells under the orginal line instead of page break InvoCare Excel Discussion (Misc queries) 1 August 29th 05 08:32 PM


All times are GMT +1. The time now is 05:23 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"