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 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Removing selected letters and symbols from a cell 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 ************************************************************************ ideacellular.com E-Mail Domain is now idea.adityabirla.com E-Mail Domain ************************************************************************ ****************************************************************************************************** Visit www.ideacellular.com to know more about latest Products, tariffs, online payments and recharges. ****************************************************************************************************** An idea can change your life. ************** LEGAL DISCLAIMER ************ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at mailad...@idea.adityabirla.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. -- ---------------------------------------------------------------------------------- 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
test.xls
Description: test.xls