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
