Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change font color on string/text values | Excel Programming | |||
Change a 1,2,3 or 4 digit number to a 6 character text string | Excel Worksheet Functions | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
How to change text string? | Excel Discussion (Misc queries) |