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 > > 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 (448|323) K34 > > BRAVO::ALPHA (459|317) K34 > > BRAVO::DELTA (463|318) K34 > > CHARLIE::BRAVO (426|330) K34 > > > > All I want to be left with is a sheet with entry’s like this: > > > > 422|279 > > 447|319 > > 445|320 > > 446|319 > > 448|320 > > 449|319 > > 448|323 > > 459|317 > > 463|318 > > 426|330 > > > > And the data that has K and a number behind it in a separate column(there > is multiple K numbers). If you could help ide be most grateful. > > > > Many thanks > > > > Alex Cargill > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
sample files.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
