I am trying to edit documents that contain numerous strings of
alpha-numeric characters, i.e. N1X3556558
N23G555681
N356M45465
What I need to do is remove the the first alpha character along with
the following numerals up to the second alpha character. I have tried
to use the text to columns feature but it doesn't work in this case
because there is no set number of numerals following my first alpha
character. Is there a way to do this in Excel?
Bookmarks