Show parentheses in table

[Dev_B_PBIing]

Hello,

I'm a newer user.  I have a table that contains a concatenated column of Idea names and a unique identifier.  I'm wanting to have the unique identifier show with parentheses and cannot figure it out.  My expression:

= Table.AddColumn(#"Changed Type2", "Unique Idea Name", each [Idea name]&" "&[Idea ID]) 

In this current setup it returns something similar to Employee Documents 70512345678453 where Employee Documents is the Idea Name and 70512345678453 is the Idea ID.  I want the Idea Id to be in parenthese like so Employee Documents (70512345678453).

I'd also like to, if possible, add a bunch of spaces between the two: Employee Documents               (70512345678453)

I really appreciate any help!

[jgeddes · Accepted solution]

You can try something like...

Table.AddColumn(#"Changed Type2", "Unique Idea Name", each [Idea name]&"     ("&[Idea ID]&")")

[Dev_B_PBIing]

Thanks that did it!  I needed the ") at the end.