LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Changing data in .csv file

Howdy from Oklahoma!!

I am not an excel person so i am having trouble with this situation.

We have a program that builds a .csv file with our payroll data that is sent
to our home office for importing into the corporate payroll system.

Now for the situation, our home office has made some changes to the
accounting system and the charge# (i.e. 77074) that we used to identify what
account the payroll time needed charged to. this charge# now is a 8-digit
number with a '850' added to the original charge# so it now it should look
like this "85077074" with the 850 in front of the original 77074.
Is there any way I can build a macro or some other wizard that i can create
for our payroll people here that can take the column that has the charge# and
do something like adding 85000000 to each charge# in the column? or if it
can just add the 850 to the beginning of each charge#???

Again, I am not an excel person so this may be a Simple Fix but i just do
not know enough about excel to set up something like this...

As Always, THANKS IN ADVANCE!!!!
Chip
 
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
Manual control of link updating for downloaded quotes? dk_ Excel Discussion (Misc queries) 9 November 15th 06 01:04 PM
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Help...Need to modify data within a column in a .csv file [email protected] Excel Worksheet Functions 11 October 26th 05 11:23 PM


All times are GMT +1. The time now is 12:30 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"