| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for finding position of numeric character in a string
Hi,
Can anyone help with worksheet function for finding position of numeric character in a string. I am trying to extract data into the form 12a345 from data that may be like any below: 12a345 12a345c 12a345_c 12ab345 12ab345c 12ab345_c Extracting the first bit is easy with LEFT() but to extract the 345 I need to find it's position in the string then I can use MID(). -- Regards, Paul. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a character at a certain position in a string of text | Excel Worksheet Functions | |||
| Finding a Character in a String Using VBA | Excel Discussion (Misc queries) | |||
| Finding a particular character in a string using VBA | Excel Programming | |||
| Finding a particular character in a string using VBA | Excel Programming | |||
| How find character position # in string from right end? Or how get range row num | Excel Programming | |||
Threaded Mode
