|
|
|
|
#1
06-04-2013, 03:29 PM
|
|||
|
|||
Hello Bob,
here is a true example: -CL/N In this case I don't want to have anything -DR/PMC00263ZP/FRU/2574/C.Q6 In this case I want to extract PMC00263ZP Please consider that the number of characters before the first "/" can differ and therefor I cannot use the LEFT formula Last edited by s7y; 06-04-2013 at 03:31 PM. Reason: extra info 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
 If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
| Extract Photographs | The Gap | PowerPoint | 4 | 04-22-2010 07:00 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode