Hi, If you attach a sample file, I think we can help you.
Regards - Dave. > Date: Wed, 23 Sep 2009 14:33:11 -0700 > Subject: $$Excel-Macros$$ Substring across a range of cells > From: sjharri...@btinternet.com > To: excel-macros@googlegroups.com > > > I have a spreadsheet populated with game score data imported from an > external source (so I can't change the format!) that consists of > between 2 and 4 cells each containing a name (variable length) and a > score (always 3 characters) in the following format; > > cell#1 cell#2 cell#3 cell#4 > name1 : 0.0 sjharris27 : 1.0 name2 : 3.0 anothername : 2.0 > > Or it could just look like this; > name4 : 1.0 sjharris27 : 0.0 > > The other names will vary from one game to another but there will > always be one with *my* name - sjharris27. What I would dearly like is > a formula I can pop into a cell on each line that will scan across all > four cells, pick up my name (or better, I suppose, a name in a > referred cell) and return the score immediately after it (e.g. 1.0 in > the first example). > > Any suggestions would be greatly appreciated. > > sjh > > > _________________________________________________________________ Need a place to rent, buy or share? Let us find your next place for you! http://clk.atdmt.com/NMN/go/157631292/direct/01/ --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
