Results 1 to 5 of 5

using left command, 3 spaces over

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2009
    Location
    va
    MS-Off Ver
    Excel 2003
    Posts
    27

    using left command, 3 spaces over

    All:

    Good morning..

    I am using the following command
    =LEFT(VLOOKUP(A6,info!$A$2:$O$217,14,0))

    and the exported data that I paste into a worksheet (Tab) seems to have 3 spaces in the cell before it hits the word for the single character I want..

    Is their a way to perform this

    Thanks again
    Last edited by vascott01; 04-07-2010 at 02:45 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1