Forum Discussion

antonio1958's avatar
antonio1958
Copper Contributor
Sep 26, 2019
Solved

Possibility to back return in an Excel cell.

How to write a procedure or formula to have in several cells a text that After a comma or others, return back starting a new ore in the same cell. This is possibile with ALT + Enter, but I need to do ...
  • antonio1958's avatar
    antonio1958
    Sep 27, 2019

    IngeborgHawighorst 

    Many Tks Ingeborg

    Yes I was looking at possibility to use Power Query functionality like split columns in row, but it is not the right way.

     

    Really it all comes from a Power Pivot where I used this formula

     

    =CONCATENATEX(Range;[Generic Job Profile and code];"; ")

     

    to have values in Pivot field. And The values (Job Profile) that is Text, is only separate by a semicolon I added in the formula.

    May be bis possible to modify this formula to get Job Profile followed by a semicolon in differerent row in the same cell ? I do manually with ALT+ENTER.

     

    Tks a lot

    Antonio