This will combine B3, C3 and D3 with '_' as the delimiter.

=B3&"_"&C3&"_"&D3

To put the dollar sign on the left and right justify the number, use the custom format

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

Ref:-

• https://www.extendoffice.com/documents/excel/3679-excel-align-dollar-sign-left.html - has screenshots; more verbose; messy layout with ads in between content;
  Afterwards
  • Find a better reference and link to it.
  • The above link has ""-"", but I get the same result with “-”. Find out if there is a difference?

To only show the dollars (but not cents)

_($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_)

tags | dollar sign left justified