J
Joe
I am trying to reconstruct hyphenated words from a document.
For example
A B C
1 The quick bro-
2 wn fox jumps
3 over th-
4 e lazy dog.
5
6 The above array needs to end up as
7
8 The quick
9 brown fox jumps
10 over
11 the lazy dog.
Can this be done easily in xl without resorting to VBA code?
The column containing the hyphenated word can vary for different rows.
The contents of the hyphenated cell (minus the hyphen) needs to be
concatenated with its next row neighbor (column A
while leaving its
own cell blanked out.
For example
A B C
1 The quick bro-
2 wn fox jumps
3 over th-
4 e lazy dog.
5
6 The above array needs to end up as
7
8 The quick
9 brown fox jumps
10 over
11 the lazy dog.
Can this be done easily in xl without resorting to VBA code?
The column containing the hyphenated word can vary for different rows.
The contents of the hyphenated cell (minus the hyphen) needs to be
concatenated with its next row neighbor (column A
while leaving itsown cell blanked out.