ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to manipulate text in one column (https://www.excelbanter.com/excel-programming/359547-how-manipulate-text-one-column.html)

cah jogja

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.



All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com