+ Reply to Thread
Results 1 to 14 of 14

Re-Post - Data Repeats in Pivot Table

Hybrid View

hutch@edge.net Re-Post - Data Repeats in... 06-21-2008, 02:33 PM
shg Thread moved. Your question... 06-21-2008, 02:50 PM
Shijesh Kumar hi, check the length of... 06-21-2008, 03:37 PM
hutch@edge.net Thanks, Kumar. 06-21-2008, 07:44 PM
Shijesh Kumar U can use TRIM function to... 06-22-2008, 05:09 AM
hutch@edge.net TRIM Doesn't work. 06-22-2008, 10:20 AM
Mikeopolo By using the code() formula... 06-23-2008, 05:03 AM
hutch@edge.net Didn't work... 06-23-2008, 10:19 AM
hutch@edge.net Bump... 06-23-2008, 11:48 AM
Shijesh Kumar Hi, I found that all the... 06-23-2008, 12:03 PM
hutch@edge.net Those won't work... 06-23-2008, 01:00 PM
Mikeopolo Hi there I have attached... 06-23-2008, 03:10 PM
  1. 06-21-2008, 07:44 PM #1
    hutch@edge.net is offline
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Thanks, Kumar.

    Thanks for that tip, Kumar. I see the problem. For some reason, some of the part numbers have a space at the end.

    Have a good one.
    Reply With QuoteRegister To Reply
  2. 06-22-2008, 05:09 AM #2
    Shijesh Kumar is offline
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    U can use TRIM function to remove the extra space that appear in the begenning or end of the string.


    =Trim(A1)
    Shijesh Kumar
    http://shijesh.wordpress.com/
    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