+ Reply to Thread
Results 1 to 3 of 3

Text to Column issue

  1. 04-01-2012, 09:31 PM #1
    Ozwilly
    Ozwilly is offline
    Forum Contributor
    Join Date
    11-02-2007
    Posts
    109

    Text to Column issue

    Hi,

    I have an index match that is looking up data however the cells it refers to (column B in the attached Excel 97 file), are indented. I have tried text to column, and also left aligning and cannot make the text in column B left align as a text entry to work in the formula. The only way I can do it is to overwrite the text, which will then left align it, and the formula will work. I have thousands of cells in this spreadsheet so it is not practical to go through and filter and overwrite them all.

    I am sure there is a simple way to fix this, I just can't find it Appreciate any help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-01-2012, 09:43 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Text to Column issue

    not sure why you are using index/math when a vlookup seems to work just fine? add trim() to the reference to remove the leading space...

    =VLOOKUP(TRIM(B3),Sheet1!$A$3:$C$7,3,FALSE)

    or use find/replace (ctrl H) to replace "space" with nothing
    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
    Reply With QuoteRegister To Reply
  3. 04-01-2012, 10:20 PM #3
    Ozwilly
    Ozwilly is offline
    Forum Contributor
    Join Date
    11-02-2007
    Posts
    109

    Re: Text to Column issue

    Thanks for your help!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1