Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not sure of what to call it accept (Un - concatenating)
Hi everyone
below I have a bit of code that gets changed constantly and places a string value in a cell. To get to this point the user needs to go through several userforms. There are 400 possible locations for this bit of code and 1,000s of combinations it can equal. If OptionButton1.Value = True The strcyl = OptionButton1.Captio ActiveCell = "-" & strsph & "x" & strcy End I Example of the result in cell B5: -1.25x-1.0 My question is, is there a way to pull this apart at a later time I'm looking too grab each of the four components above and place them in four different cells in another workbook I appreciate any help that anyone can give Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenating | Excel Worksheet Functions | |||
concatenating | Excel Discussion (Misc queries) | |||
Concatenating % | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Concatenating | New Users to Excel |