Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We get data in a report that is indecipherable. I need to extract all switch numbers following a "$" that preceed a "-1".
for example from the following output I need the following results. Note that each long string is contained in one cell. Output Results $1$2$3$4$5$6$7$8$9$10$11$25$50$51$52$99 null $1-1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$28 $30$31$32$33$50$51$52$53$54$55$60$61$80$85$97$98$9 9 1 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$2 8$30-1$31-1$32$33$40$50$51$52-1$53$54$55$60$61$70$80$85-1$97$98$99 30,31,52,85 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$25$26$27$28$3 0-1$31-1$32$50$51$52$53$54$55$80$85$97$98-1$99-1 30,31,98,99 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$2 8$30-1$31-1$32$33$40$50-1$51$52$53$54-1$55$60$61$70$80$85-1$97$98$99-1 30,31,50,54,85,99 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$2 8$30-1$31-1$32$33$40-1$50$51$52$53$54$55$60$61$70$80$85$97$98$99-1 30,31,40,99 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$2 8$30-1$31-1$32$33$40$50$51$52$53$54$55$60$61$70$80$85$97$98-1$99-1 30,31,98,99 $1$2$3$4$5$6$7$8$9$10$11$12$13$14$15$16$25$26$27$2 8$30-1$31-1$32$33$40$50$51$52$53$54$55$60$61$70$80$85$97$98-1$99-1 30,31,98,99 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If I have a list of numbers, how do I insert a dash in each one? | Excel Discussion (Misc queries) | |||
Adding a dash to phone numbers | Excel Discussion (Misc queries) | |||
Extract number between a dash | Excel Discussion (Misc queries) | |||
inserting a dash into a column of numbers | Excel Worksheet Functions | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |