Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Help...Need to modify data within a column in a .csv file | Excel Worksheet Functions |