Modify cells within an Excel file - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Basic Scripting » Modify cells within an Excel file

Page 1 of 1

1

Topic Options

#120567 - 2004-06-03 04:28 PM Modify cells within an Excel file
coxmcse coxmcse Fresh Scripter Registered: 2002-01-18 Posts: 25 Loc: Maryland, USA	I have an Excel file that has four columns and 762 rows all with data inside. In two of these columns I need to place "SMTP:" at the beginning of the data located in the cells. Any idea how that can be done by script? Thanks for your help. _________________________ E. Cox Baltimore, MD If a man does his best, what else is there? George S. Patton
Top

#120568 - 2004-06-03 04:55 PM Re: Modify cells within an Excel file
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	there are already udf's written that read and write to excel, the rest is only a bit string manipulation ... Do a search on udf forum _________________________
Top

#120569 - 2004-06-03 05:07 PM Re: Modify cells within an Excel file
coxmcse coxmcse Fresh Scripter Registered: 2002-01-18 Posts: 25 Loc: Maryland, USA	Thank you, I will. I also just found the concatenate function in Excel which might work just as well. Thanks again! _________________________ E. Cox Baltimore, MD If a man does his best, what else is there? George S. Patton
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart

Hop to:

Shout Box

Who's Online

1 registered (Henriques) and 2516 anonymous users online.

Newest Members

fgarcia, Viginette, ManuvdWielNL, Sir_Barrington, batdk82
17889 Registered Users

Generated in 0.049 seconds in which 0.023 seconds were spent on a total of 12 queries. Zlib compression enabled.

click tracking