Re: Help with very repetitive task in excel...is there an answer?
From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 07/26/04
- Next message: Amedee Van Gasse: "Re: Maths-Integration"
- Previous message: Nick: "Re: Range type variable oddness"
- In reply to: Ken Wright: "Re: Help with very repetitive task in excel...is there an answer?"
- Next in thread: Tim Smith: "Re: Help with very repetitive task in excel...is there an answer?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Jul 2004 09:42:25 +0100
Correction on last statement
> simple concatenate in C1, eg =A1&B1
replace with
simple concatenate in C1, eg =B1&"<br><br><br>"&A1
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:u6EQ0sucEHA.4092@TK2MSFTNGP10.phx.gbl...
> Assuming your data is in Cols A and B as stated, then in C1 put the following
> and then copy down
>
> =LEFT(B1,FIND("<br><br><br>",B1)+11)&A1
>
> Now edit the text as required in Col A and this will be reflected in Col C.
> When done, simply copy Column C and then paste special as values.
>
> Note, this assumes that in each line of html, you have only one section with 3
> <br>s and that that section is immediately prior to the text.
>
> The other option is simply to do an Edit / replace on <br><br><br>*
which
> will delete all text at the end of every statement. Then you can just use a
> simple concatenate in C1, eg =A1&B1, again copying and paste special as values
> when done.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
>
>
> "Tim Smith" <timbo@telpacific.com.au> wrote in message
> news:4104a946$1@news.rivernet.com.au...
> > Hi all,
> >
> > Ok, here's the challenge...
> >
> > I've got a csv database of text to upload (sql) to my website database. This
> > database contains all of the information on books that I sell (approx. 1700)
> > the only problem is, is that I've got two columns of the same text (book
> > descriptions) that needs to be amended / revised to be the same. That's the
> > long and relatively easier part of the job.
> >
> > Column A - Has the text description of the book ie. "Instructions & colour
> > photos for a variety of socks for all the family".
> >
> > I want to amend this text and then copy and place in Column B - the trick
> > is, column B has my html code ie. AUTHOR:
> > KNITTING<br>EDITION: Hardcover<br>ISBN: 1930500084<br>PAGES:
> > 96<br>SIZE: 140mm x 180mm<br><br><br>Instructions & colour photos for a
> > variety of socks for all the family.
> >
> > As you can see, the text I want to replace (with what I've amended in column
> > A) is at the end of this html code. So, short of copying and pasting nearly
> > 2000 lines of text, is there something I can use / do that will copy text
> > from column A and replace / paste at the end of the code in Column B at a
> > specific point (ie. after the third <br> point.
> >
> > This may look a bit weird, but the company I obtained the database from
> > supplied it on a - what you see is what you get basis, in other words, if I
> > want to use it, I've gotta fix it myself.
> >
> > I hope that explains - here's hoping someone can assist!
> >
> > Tim.
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004
- Next message: Amedee Van Gasse: "Re: Maths-Integration"
- Previous message: Nick: "Re: Range type variable oddness"
- In reply to: Ken Wright: "Re: Help with very repetitive task in excel...is there an answer?"
- Next in thread: Tim Smith: "Re: Help with very repetitive task in excel...is there an answer?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
