LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Help with very repetitive task in excel...is there an answer?

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<brEDITION:&nbsp;Hardcover<brISBN:&nbsp; 1930500084<brPAGES:&nbsp;
96<brSIZE:&nbsp;140mm x 180mm<br<br<brInstructions & 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.


 
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
Calculator Answer Doesn't Match Excel Answer GwenH Excel Discussion (Misc queries) 3 October 20th 08 10:17 AM
how do I remove repetitive cells in an excel database? jjr1975 Excel Discussion (Misc queries) 5 January 15th 08 04:27 AM
Repetitive Data in Excel Exceldummy Excel Worksheet Functions 1 October 16th 06 04:06 PM
repetitive Repetitive formula Excel Discussion (Misc queries) 2 June 28th 06 05:59 AM
Repetitive task macro twaccess[_17_] Excel Programming 7 July 22nd 04 08:47 AM


All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"