RE: $$Excel-Macros$$ Removing selected letters and symbols from a cell

2010-08-19 Thread Hitesh Dilipbhai Dhare
To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Removing selected letters and symbols from a cell Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24 AALPHA::HOTEL (447|319) K34 ALPHA::FOXTROT (445|320

Re: $$Excel-Macros$$ Removing selected letters and symbols from a cell

2010-08-18 Thread Ramkesh Maurya
Dear Cargill, I have prepared formule based on your file Regards Ramkesh On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill < zanderman1...@googlemail.com> wrote: > > > > > Hi all I was wondering if you could help. I have a sheet with entrys into > a cell that looks like this: > > > > AAECHO:

Re: $$Excel-Macros$$ Removing selected letters and symbols from a cell

2010-08-18 Thread ashish koul
check the attachment Regards Ashish akoul.blogspot.com On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill < zanderman1...@googlemail.com> wrote: > > > > > Hi all I was wondering if you could help. I have a sheet with entrys into > a cell that looks like this: > > > > AAECHO::DELTA (422|279) K24

$$Excel-Macros$$ Removing selected letters and symbols from a cell

2010-08-18 Thread Alexander Cargill
Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24 AALPHA::HOTEL (447|319) K34 ALPHA::FOXTROT (445|320) K34 ALPHA::GOLF (446|319) K34 ALPHA::INDIGO (448|320) K34 ALPHA::JULLIET (449|319) K34 ALPHA::KILO