Have a list of about 250 numbers (with 3 decimals there are 4 set of numbers within the number I am working with).
Step 1 - I want to put an x as the beginning digit and an x as the ending digit
Step 2 - Have about 250 "replace this", "with this" that I want to run against the 250 rows that would be reading something like this x00.0.000.00x after step 1 is run.
I have named the top cell of numbers as "Top", and the last cell of numbers as "bottom"
Thanks
if you just want a simple formula to copy down, try this, assuming your data starts in A1 - adjust as needed...
="x"&A1&"x"
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I know how to do in manually. I am here because I need a macro to do exactly what you show - and another macro to do step 2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks