I have Done it with formula Check it.... if you have any other query Arif Mansoorali Massani Bhavnagar Gujarat, India M. +91-9913382099
On Wed, Aug 18, 2010 at 8:20 PM, Michael Hayes <m99pan...@gmail.com> wrote: > Alex, > > This a "Text to Columns" function. Select the column, use the Text to > Columns/ delimited function with "space" as an indicator. > > In Excel 2007 "Text to Columns" can be found on the Data tab. > > On Aug 18, 4:51 am, 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
Solved.xls
Description: MS-Excel spreadsheet
