Macro to parse thru csv file & change value in a column to a substring value

[puffster]

Hello,

I work for the school system in Louisville, KY. We are using third party software to conduct a staff survey. I can export the responses to this survey into a CSV file. One of the things I need to do is read a column that contains the respondants location (i.e., Rangeland - 123) and change the value to only be the location number -- the three-digit value at the end of the location (123 in the above example).

I would like to create a macro that does this for me. The two challenges I have bumped into are: 1) How to create a macro that is based on a dynamic # of incoming records; and 2) how to not make the function I'm using a recursive call. The location column will be F, and I have created this function that works if I use it from another column, but I get fussed at for it being recursive if I try to run it from the cell for which it's intended:

Please Login or Register  to view this content.

Any help with one or both of my issues would be very greatly appreciated!!

[davegugg]

How does this work for you:

Please Login or Register  to view this content.

Put this sub in a standard module. You must have the csv. file open and active.

[puffster]

Dave,

As a Seahawks fan, this is really hard for me to say to a 49ers fan...but You Da Man!!

I'm new to Excel Macros...but this works perfectly. Thank you so much for your help, it is very much appreciated!!

[davegugg]

You're welcome.
And by the way, I wouldn't think it'd be too hard after this last Sunday, and I'd love to say something about the officiating, but we'll leave that for a different type of forum ; )