Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

concatenate values

I need to unite the values of fields of type text in two different tables, how can I do?
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Hi Anonymous,

     

    You can nested CONCATENATE() within CONCATENATE() to add concatenate more characters you need.

     

    CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

Hi Anonymous,

 

You can nested CONCATENATE() within CONCATENATE() to add concatenate more characters you need.

 

CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))

 

Regards,

DSimma's avatar
DSimma
Advocate IV
10 years ago

I would usually just do the excel way ie. =(Value1)&" - "&(Value 2), I find it quicker and easier then using a function.