| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Values from a String
Hi everybody,
I have the following in Cell B2 :- LD(24,6,3,6)=163 How can I extract with VBA the ... 24 < this could be 3 digits 6 < this could be 2 digits 3 < this could be 2 digits 6 < this could be 2 digits 163 < this could be 4 OR 5 digits .... so they go in Cells E6:E10 please. There will always be a comma and the final figure will always follow the = sign. Thanks in Advance. All the Best. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract a value from mid string | Excel Programming | |||
| Extract from string | Excel Discussion (Misc queries) | |||
| extract string | Excel Programming | |||
| Extract sub string | Excel Worksheet Functions | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Threaded Mode
