RE: Finding, Replacing and Cut & Paste
- From: Miguel Zapico <MiguelZapico@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Apr 2006 11:16:03 -0700
This wouldn't do exactly what you want, but at least you will have part of
the copy and paste made.
Add a new column 4, with the following formula (put it on cell D2 for this
references)
=IF(A2="",IF(ISERROR(FIND("-",D1)),D1 & " - " & B2,LEFT(D1,FIND("-",D1)-2) &
" - " & B2),B2)
This will transform this:
94 LANDINO, Carl
will 3/8/1974
trust agmt. 3/6/1974
Into this:
94 LANDINO, Carl LANDINO, Carl
will 3/8/1974 LANDINO, Carl - will
trust agmt. 3/6/1974 LANDINO, Carl - trust agmt.
It is not the full solution, but you can copy, paste values on the whole
column and play a little with sort/filter after that. Maybe you can avoid
the 25000 cut and paste :)
Miguel.
"cs_vision" wrote:
I have the following Excel Spreadsheet setup:.
Col 1 Col 2 Col 3
94 LAMPKIN, Louis William
will 3/15/04
decl. of trust 3/15/04
living will decl. 3/15/04
p/atty – prop. 3/15/04
p/atty – h/c 3/15/04
94 LANDINO, Carl
will 3/8/74
trust agmt. 3/6/74
94 LANDINO, Dorotha Mae
will 3/8/74
trust agmt. 3/6/74
94 LANDMAN, Edward
will 10/2/83
Each name every name in Caps is one section. What I need to do is take the
name and combine it with the wording below for each date. For example
94 LANDMAN, Edward
wil 10/2/83
trust 6/8/83
BECOMES:
94 LANDMAN, Edward - will 10/2/83
LANDMAN, Edward - trust 6/8/83
Is there a fast way to do this without cutting an pasting? I have over
25,000 entries?
- Follow-Ups:
- RE: Finding, Replacing and Cut & Paste
- From: cs_vision
- RE: Finding, Replacing and Cut & Paste
- Prev by Date: Re: Matching and calculating 2 worksheets
- Next by Date: Re: How can I move several columns of words into one column in Exc
- Previous by thread: Re: why don't my totals change when I enter additional data?
- Next by thread: RE: Finding, Replacing and Cut & Paste
- Index(es):
Relevant Pages
|
