Thread: Carriage return in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
  
Posts: 83
Default Carriage return in a cell
How can I replace each comma followed by a space with a carriage-
return?

For example, a cell contains:

COL-ACTN-TYPE, COL-ACTN-NBR, ET-AL-IND


I want:

COL-ACTN-TYPE
COL-ACTN-NBR
ET-AL-IND



Reply With QuoteReply With Quote