Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to manipulate text in one column
dear all,
sorry for rmy poor english, hope subject title can work :). i use this program for identify flight route, i use text for dget criteria etc: A B C 1 CODE DETAIL 2 JOGCGK JOGJA to JAKARTA / JAKARTA to JOGJA 3 JOGDPS JOGJA to BALI / BALI to JOGJA 4 JOGSUB JOGJA to JAKARTA / JAKARTA to BALI 5 6 =DGET(A1:B4;"DETAIL";A8:A9) 7 8 CODE : 9 10 my problem is come up when the criteria is the return flight route. on the criteria for A2 is CGKJOG instead JOGCGK. how to make those criteria flight route also can be used as its return flight or for example i can use JOGCGK as CGKJOG. i really need the solution because there are thousand of routes. thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manipulate an 2D Array into a Column Array? | Excel Discussion (Misc queries) | |||
How to manipulate a row with a certain value | Excel Programming | |||
Find a specific text item and manipulate cells surrounding | Excel Programming | |||
Manipulate an excel column | Excel Worksheet Functions | |||
Can you manipulate text documents using VBA in excel | Excel Programming |