excel issue with concat function

Job ID: 35234652

Budget: $10 – $30 USD

I need help combining text from various columns into 1 column and my concat function is giving me problems.
Related categories: Visual Basic Data Processing Data Entry Excel