carraige return within a cell & capitalization
Olvarski,
It would be immensely helpful if you posted your code/formulas.
HTH,
Bernie
MS Excel MVP
"Olvarski" wrote in message
...
In cells A1:A30 I've got my original values, which are text sentences, and
anywhere between 40 and 70 characters long. Cells B1:B30 I've put a
varation
of Sub Shuffle30Values() found elsewhere on these boards to create a
random
order of lookup values. Cells C1:C5 list punctuation/conjunctive words;
cell
D1 concatenates and merges the first five values of B and C to form a
"proper" randomly generated sentence with punctuation (at the moment I've
got
the output set to LOWER).
The first thing I need to do is get the output of this cell to be in
"proper" English, so that the first letter, and any letter appearing after
a
full stop, are capitalized.
The second thing I need to try and do is insert a carraige return within
the
cell after 45-50 characters, but so that it isn't inserted in the middle
of a
word.
Current output:
line 1 has fifty characters, whilst line 2 has fifty characters and line 3
has fifty characters. line 4 has fifty characters but line five has fifty
characters.
Desired output that can be copied over to word:
Line 1 has fifty characters, whilst
line 2 has fifty characters and
line 3 has fifty characters.
Line 4 has fifty characters but
line 5 has fifty characters.
Any suggestions on how to modify the output?
|