Results 1 to 4 of 4

Thread: Replace doesn't carry forward to Excel

  1. #1
    Neophyte gwaldram's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    Excel 365

    Replace doesn't carry forward to Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I created a Replaced Value

    = Table.ReplaceValue(#"Changed Type","","A9000",Replacer.ReplaceValue,{"IDITEM"})

    but upon Close & Load, the item appears as a blank.

    If I filter IDITEM to only include A9000 they load perfectly.

    I just got a new computer and it was working on my previous computer. I'm guessing it is a setting somewhere.

    I'm lost as to what the problem is.

    Thanks in advance.

    Gerry

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,530
    Articles
    0
    Excel Version
    Office 365 Subscription
    Provide a sample workbook displaying the problem.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte gwaldram's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    Excel 365

    Attachments

    Click image for larger version. 

Name:	power query editor.jpg 
Views:	26 
Size:	93.2 KB 
ID:	10196Click image for larger version. 

Name:	excel.jpg 
Views:	23 
Size:	97.0 KB 
ID:	10197

    I could not attach the file as it was too large. I downloaded screenshots. As you can see the IDITEM in power query shows A9000, but once I Close & Load they do not load into the Excel spreadsheet.

    Thanks,

    Gerry

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,530
    Articles
    0
    Excel Version
    Office 365 Subscription
    Looks like it's to do with the spaces - have you tried widening the column? Other than that, I'd need to see a sample. Cut down the workbook to produce a small subset of data that causes the problem and attach the workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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