| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Find and Replace
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| Excel 2003 Find and Replace is changed to previovois ver.-awful!! | Excel Discussion (Misc queries) | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| find and replace links in Excel 2003 | Excel Worksheet Functions | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
