Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting hyphenated numbers | Excel Discussion (Misc queries) | |||
sorting hyphenated numbers | Excel Discussion (Misc queries) | |||
Apply Sumprod on mix text & numbers arrays | Excel Discussion (Misc queries) | |||
how do I preserve hyphenated words | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |