View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vertblancrouge vertblancrouge is offline
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