You can use Mid and RIGHT formula to take the required data
See attached Excel for the details
With Regards,
Hitesh
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Alexander Cargill
Sent: Wednesday, August 18, 2010 5:21 PM
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:
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
