ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Elimination of split(hyphenated) text in arrays (https://www.excelbanter.com/excel-discussion-misc-queries/141526-elimination-split-hyphenated-text-arrays.html)

Joe

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