| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed to Omit Characters
Is there a formula that would recognize and omit specific characters within a field? Example: Data Field has the following 9 characters "R0502AA01". Only the following 7 characters: "R0502--01" should be picked up or recognized. What formula will pick up the 1st-5th and the 8th-9th characters and bypass the 6th & 7th characters? Addie -- addie ------------------------------------------------------------------------ addie's Profile: http://www.excelforum.com/member.php...o&userid=25526 View this thread: http://www.excelforum.com/showthread...hreadid=513674 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| formula results take up to 2 lines if needed, but keep border | Excel Worksheet Functions | |||
| Formula Needed! | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
| Formula Does Not Omit Criteria | Excel Worksheet Functions | |||
Threaded Mode
