Hi all,
I'm using Excel 2010 and I'm working on a worksheet where I need to perform a VLookup on a specific column (say Col. B) that contains a long list of names. Problem is some of the names in that list end with a comma. Since the lookup table have the names without the commas, I'm having a real headache going through the list to eliminate the commas!
Is there a formula that can help me to remove the commas in those names?
2 ways i can think of off-hand to do this....
=vlookup(left(B2,len(B2)-1),the=rest=of=your=vlookup-formula)
use a helper column in the lookup table, use =left(a1,len(a1)-1) to remove the comma, and then use vlookup() IF you put the helper to the far left of the data - or index/match if you add it to the right
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You could hightlight the column list that has the commas and use the replace text. Crtl H - put the comma in the "Find What" box and leave Replace with blank
If you don't have any text within the list with duplicate text you can use VLOOKUP with wildcards
=VLOOKUP("*"&A1&"*",$G$1:$H$3,2,0)
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Thank you FDibbins and The Cman81 for your help! I'll give both solutions a try and report back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks