| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
split prefix and suffix
C22K001
C15K015A FA28K005A Hi, Could someone help me to split the cell and drop the prefixes C and FA as well as the suffix A? What will be left will read 22K-001, 15K-015 or 28K-005. Thanks for the help. Ray |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Barcode suffix ean128 | Excel Discussion (Misc queries) | |||
| Prefix and Suffix | Excel Discussion (Misc queries) | |||
| How do I had a suffix to a cell i.e. -1,-2,-3? | Excel Discussion (Misc queries) | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| I'd like to add a suffix... | Excel Discussion (Misc queries) | |||
Threaded Mode
