![]() |
Elimination of split(hyphenated) text in arrays
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. |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com