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
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
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::DELTA