Need help formatting a cell
 

I have text in a cell in Google sheets which is formatted like this:

Name #XXXXX

I want to put it in this format but am unsure of how to do so:

Name (#XXXX) - AAA

Can anyone assist?

Need help formatting a cell
 

Try:

="(" & [YourCell] & ") -" & " AAA"

HTH