locked
How do I remove text (empty) in the cells of PowerPivot table. RRS feed

  • Question

  • (tom) = (empty) in Swedish.

    ACTIVID Ansvarig Start   datum Aktivitetstyp Ämne Medarbetare Kontakt Titel Kont Förnamn Kont   Efternamn
    11204 Fredrik 2013-12-02 Månadstillsyn Lagers Tillsyn December 2013 (tom) (tom) (tom) (tom)
    11204 Fredrik 2013-12-02 Månadstillsyn Lagers Tillsyn December 2013 (tom) IT ansvarig Peter Lager
    11205 Fredrik 2013-12-03 Månadstillsyn Nifab tillsyn December (tom) (tom) (tom) (tom)
    11205 Fredrik 2013-12-03 Månadstillsyn Nifab tillsyn December (tom) Verkställande direktör Fredrik Sandberg
    11206 Fredrik 2013-12-03 Månadstillsyn Bramberg tillsyn December 2013 (tom) (tom) (tom) (tom)
    11206 Fredrik 2013-12-03 Månadstillsyn Bramberg tillsyn December 2013 (tom) Läkare Kenneth Bramberg
    11208 Fredrik 2013-12-04 Månadstillsyn Geovista tillsyn December 2013 (tom) (tom) (tom) (tom)
    Wednesday, January 8, 2014 8:10 AM

Answers

  • I'll get the value using the = RELATED (contact [name]), what do I write when no hit to not get (tom)/(empty)?
    Wednesday, January 8, 2014 9:33 AM
  • The easiest way is first to add a calculated column with RELATED to get the value and then a second calculated column with the IF statement to remove "(tom)"; but of course you can combine RELATED and IF in one calculated column, like:

    =IF(RELATED(...) = "(tom)", "", RELATED(...))


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, January 8, 2014 9:47 AM

All replies

  • On what basis you determine whether value is empty or not?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, January 8, 2014 8:17 AM
  • Hello Göran,

    You can use a IF statement to replace "(tom)" with e.g. a blank value

    =IF(Tbl[Kont Förnamn] = "(tom)", "", Tbl[Kont Förnamn])


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, January 8, 2014 8:36 AM
  • I'll get the value using the = RELATED (contact [name]), what do I write when no hit to not get (tom)/(empty)?
    Wednesday, January 8, 2014 9:33 AM
  • The easiest way is first to add a calculated column with RELATED to get the value and then a second calculated column with the IF statement to remove "(tom)"; but of course you can combine RELATED and IF in one calculated column, like:

    =IF(RELATED(...) = "(tom)", "", RELATED(...))


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, January 8, 2014 9:47 AM
  • Thanks for the help, I didwrite=if (RELATED(contact[name]) =BLANK(), " ",RELATED(contact[name]))andthenförsvantext (Tom).

    Regards

    Göran

    Wednesday, January 8, 2014 10:59 AM