Text Join Formula

Brittanyy

Hi there,

I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked

but I need assistance on changing the order of it.

Course Date with Parentheses around the date and Couse Name

Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work

Example what I want: (11/13/23) Introduction to Law

Matt Johnson

Hi @Brittanyy

I don't think you ever needed the JOIN part. Please try this one. I think it will work.

="("+[Course Date]@row+") "+[Course]@row)

I hope that helps.

Matt

Matt Johnson

Hi @Brittanyy

I don't think you ever needed the JOIN part. Please try this one. I think it will work.

="("+[Course Date]@row+") "+[Course]@row)

I hope that helps.

Matt

NickStaffordPM

To @Matt Johnson's point, the JOIN function is Throwing it off. If you remove it, it should be fine... Could you confirm for us? I am interested to know this solution

Brittanyy

@Matt Johnson and @NickStaffordPM

This formula worked without the Join.

="("+[Course Date]@row+") "+[Course]@row)

Thank you so much for the assistance.