Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to manipulate an 2D Array into a Column Array? Joe Excel Discussion (Misc queries) 3 April 16th 07 06:30 PM
How to manipulate a row with a certain value Bill Excel Programming 4 February 24th 06 01:59 PM
Find a specific text item and manipulate cells surrounding RichHoughton Excel Programming 1 August 5th 05 01:06 PM
Manipulate an excel column Bill R Excel Worksheet Functions 2 May 17th 05 07:01 PM
Can you manipulate text documents using VBA in excel Sladey Excel Programming 1 May 17th 04 05:11 PM


All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"