View original (French)

Remove space in POWER PIVOT

Solved
pijed Posted messages 41 Status Member -  
pijed Posted messages 41 Status Member -
Bonjour,

I have a PowerPivot table with SIREN numbers. Some have spaces AAA BBB CCC, while others do not. Is there a formula to create a new column in POWER PIVOT with the SIREN numbers without spaces?

Thank you in advance.

3 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    Hello.

    I don't know Power Pivot; but Excel easily allows you to remove spaces:
    in B1, enter the formula =SUBSTITUTE(A1," ","")
    --
    Retirement is great! Especially in the West Indies...
    Raymond (INSA, AFPA)
    0
  2. pijed Posted messages 41 Status Member
     
    Hello,

    I am indeed having trouble with this formula in Power Pivot.
    I need to transform a column with SIREN numbers with or without spaces, with or without letters (as there are foreign SIREN numbers) into a number column when the cell resembles a number.
    0
  3. pijed Posted messages 41 Status Member
     
    Actually, it works very well. Thank you very much.
    0
    1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
       
      Oh! You scared me...
      0
    2. pijed Posted messages 41 Status Member
       
      I hope the fear wasn't too strong. Thank you very much!
      0