Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting hyphenated numbers Connie Martin Excel Discussion (Misc queries) 5 February 20th 09 12:57 PM
sorting hyphenated numbers punkster Excel Discussion (Misc queries) 3 February 26th 07 04:28 PM
Apply Sumprod on mix text & numbers arrays Nir Excel Discussion (Misc queries) 4 October 30th 06 01:11 AM
how do I preserve hyphenated words coultwo Excel Discussion (Misc queries) 2 August 31st 06 04:17 AM
text cells end page how split to next. Text lost! Elaine Excel Discussion (Misc queries) 1 August 28th 05 05:48 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"