change text in string
Oops... my bad. I see they are entire strings to begin with, not
individual cells.
You can do what I showed though... looping through looking for the
hyphen, taking all after, then looking for the comma, and taking all
before, taking the remainder of the string, then doing it all over
again until you have gone through the string, assembling the new
string as you go.
SMS
On Oct 5, 1:02*pm, "CG Rosen" wrote:
Hi Group,
Need some hints how to approach this problem;
In a cell I have a text string like "10-1,10-2,10-3,10-4" or the string
could be as
"1-1,1-2,1-3" or even "100-1,101-2"
I want the string to be converted to look like "1,2,3,4....etc
Grateful for some help.
Brgds
CG Rosen
|