View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Craig
 
Posts: n/a
Default Excel: replace all 2 spaces to FF/LR in column of text

I am dumping a tab-delimited file into Excel 2002 which results in 6 columns
(Title, Assigned To, Due Date, Log). The Log field can be quite long and be
a concatentation of comments from different sources/users. When displaying
in Excel, the comments in the Log field run together (but it appears that the
break point should be where there are two spaces next to each other). I have
tried all I can think of to replace any occurrence of 2 spaces with a
LineFeed and FormFeed (aka ALT-ENTER) ... but with no luck.