| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting part of string value
I have a string value that varies in length. The first 13 characters I am not interested in, but the last part I'm interested in extracting. Here is a data example
SCR0334535 @ 0.01µ SCR0334535 @ 0.03µ SCR0334535 @ 0.1µ SCR0334535 @ 0.3µ SCR0334535 @ 1µ SCR0334535 @ 3µ SCR0334535 @ 10µ SCR0334535 @ 30µ SCR0334535 @ 100µ How can I get the last part (character 14 and onwards) assigned to a new variable Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting part of a cell | Excel Worksheet Functions | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| Extracting part of data | Excel Discussion (Misc queries) | |||
| Extracting part of a cell | Excel Worksheet Functions | |||
| Extracting Part of a Date | Excel Discussion (Misc queries) | |||
![Dr. Schwartz[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
