| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
