| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Insert Line Break-Macro"-Thanks Bob, but..
Hey Bob,
Thanks for the code, but there's a problem. The output looks like this: 166930.000000 5272038.000000 1 1.500000 165949.000000 5272484.000000 1 1.500000 165325.000000 5273019.000000 1 1.500000 164879.000000 5273733.000000 1 1.500000 164826.000000 5273945.000000 1 1.500000 163541.000000 5273019.000000 2 1.500000 163720.000000 5274804.000000 2 1.500000 163987.000000 5276409.000000 2 1.500000 But I would like it like this: 166930.000000 5272038.000000 1 1.500000 165949.000000 5272484.000000 1 1.500000 165325.000000 5273019.000000 1 1.500000 164879.000000 5273733.000000 1 1.500000 164826.000000 5273945.000000 1 1.500000 163541.000000 5273019.000000 2 1.500000 163720.000000 5274804.000000 2 1.500000 163987.000000 5276409.000000 2 1.500000 The number after 1,2.....till 379. I would need to have a line breaks after all the 1's, the 2's and like that till the last one, ie. 379 Any suggestion? Cheers Elvis --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a "Target" line into basic bar chart | Charts and Charting in Excel | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Is there a formula thet reads (If A2=A1,"",INSERT PAGE BREAK) ? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| "Insert Line Break-Macro" | Excel Programming | |||
![vernerv[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
