I didn't realize that the formatting would change, while i am at it, i would like to search for 1a or 1b or 1c and have it put the corresponding location in the appropriate cell. please see attachment.
Thanks again, Steve On Sun, Jan 24, 2010 at 5:49 PM, Steve <mck1...@gmail.com> wrote: > > A B > > 1 ILLINOIS vs. IOWA 1a > Tampa Fla. > > "1a" is a location code and is equal to Tampa Fla., Cell A1 contains > the two competing teams plus "1a". I want to search for "1a" in A1 > and when it is found have excel return the location(Tampa Fla.) in a > new cell (B1). > > This problem seems very easy, but i am having trouble getting exactly > what i need. > > Thanks for the help, > Steve -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
