I'm not quite sure what you mean by using find/replace. I realize you want to replace "1a" with "2", but perhaps there's more to it than that.
I'm not sure if you're looking for a VBA solution, or a Excel "menu" solution? Is the data sorted? or are you intending to perform this replacement to ENABLE a sort? We could easily split the line using the "." as a delimeter, load the lines into an array. sort the array, output the array, using the array index instead of the first element (1a,1b, etc.) But, before I spend a whole bunch of time developing a wild approach to a problem that turns out to be nothing like what I thought I was dealing with, perhaps I need some more information, and perhaps a larger sample of data... Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Paul <p...@paulkaye.net> To: excel-macros@googlegroups.com Sent: Mon, November 5, 2012 5:05:03 AM Subject: $$Excel-Macros$$ iterative / sequential find and replace Hi, I frequently have lists, each entry of the list is a one-sentence paragraph ending in a full-stop (period), and is prefixed by a non-sequential number or letter or combination, followed by a full-stop and then a tab. So, it might look like this (tabs are shown as arrows, for clarity): 1.→People like to help in online forums. 1a.→Hopefully they will be able to help this time. x.→I'll be a little stuck without some help with this. The reason that the prefix is non-sequential and unpredictable is that the order of the list is shuffled about a lot during editing, and for reasons I can't explain here, I cannot use MS Word's autonumbering feature. Once the list has been finalized, I have to renumber the entries sequentially: 1.→People like to help in online forums. 2.→Hopefully they will be able to help this time. 3.→I'll be a little stuck without some help with this. Can anyone suggest how to do this? The lists are consistent enough that I think it should be possible to "find" "^p*.^t", but (assuming this is correct), I don't know how to get the "replace" bit to work the way I want. Any help would be most appreciated! Thanks, Paul -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
