| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
STRINGS AND SUBSTRINGS !
If a cell contains a single string like "VBA is nice to know". How do I use vba (programmatically)to write the 5 substrings "VBA" "is" "nice" "to" "know" in five different cells (ie one substring per cell)? Assume the main string is in cell A2, and the substrings go into cells C2, D2, E2, F2, and G2 respectively. Please note that I will **need** a macro. Any help would be greatly appreciated! Thanks Jay Dean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to apply parsing rules for strings and list the substrings | Excel Worksheet Functions | |||
| sum wrt substrings! | Excel Worksheet Functions | |||
| Substrings in Excel? | Excel Discussion (Misc queries) | |||
| Searching for Substrings Within Strings | Excel Discussion (Misc queries) | |||
| Finding substrings within a string | Excel Programming | |||
Threaded Mode
