LinkBack URL
About LinkBacks
Trying to use begins with to provide a result, see attached file.
Something like - if the cell starts with GL, then place GL, if cell starts with WD then place WD, you'll see what i'm after in the file.
thanks in anticipation.
Trying to use begins with to provide a result, see attached file.
Something like - if the cell starts with GL, then place GL, if cell starts with WD then place WD, you'll see what i'm after in the file.
thanks in anticipation.
Last edited by Christopherdj; 11-07-2011 at 09:30 PM.
=IF(LEFT(B2,2)="GL","GL,"")
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you, I knew the answer was simple, and I only had to add additional criteria to cover it all off.
Fantastic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks