Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have text that looks like this:
### FOUR SCORE and seven years ago our fathers brought forth on this continent A NEW NATION conceived in liberty and dedicated to the proposition that all men are created equal NOW WE ARE ENGAGED in a great civil war testing whether that nation OR ANY NATION so conceived and so dedicated can long endure WE ARE MET ON A GREAT battle-field of that war ### There is no regularity to the number of lower-cased rows between the capitalized rows, nor is there any regularity to how many letters are capitalized at the beginning of the capitalized rows. I want the output to look like this, so that Excel combines rows, adding a space at the front and starting a new row when it hits a capital letter: ### FOUR SCORE and seven years ago our fathers brought forth on this continent A NEW NATION conceived in liberty and dedicated to the proposition that all men are created equal NOW WE ARE ENGAGED in a great civil war testing whether that nation OR ANY NATION so conceived and so dedicated can long endure WE ARE MET ON A GREAT battle-field of that war ### And to make things even more complicated, sometimes the lower-cased rows actually start with a single capitalized letter. So really, I want it to start a new row when it hits more than TWO capital letters in a row. Any ideas? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to combine data based on two fields.. | Excel Discussion (Misc queries) | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Combine data in rows based on two citeria | Excel Programming | |||
combine 2 tables of data into one based on date | Excel Worksheet Functions | |||
Macro to combine data based on IF,THENs? | Excel Programming |