merging 3 columns into 1

[Heliops]

Hi there, I have 3 columns of data in the following format: 1234 99 1234567 and I want to get it all into one column but in 2 different formats as such: 1234991234567 and 1234-99-1234567.

Would be most grateful for any help

 

[kweaver]

If you concatenate them in D, you'll string them together as text.

=A1&B1&C1

If you have Flash Fill (Excel 365 or 2016) you can use that in E by typing the pattern 1234-99-1234567 into E1 and then from the Data tab, run Flash Fill.

Alternatively,

=A1&"-"&B1&"-"&C1

 

[ParamRay]

Assuming your values are in cells A1, B1 and C1...

You can combine them without hyphens like this:

= CONCAT( A1:C1 )

Or you can combine them with hyphens like this:

= TEXTJOIN( "-", TRUE(),  A2:C2 )

 

[Heliops]

superb, especially the Flash Fill method, so clever. Thnaks

 

[Heliops]

many thanks for yr help, much appreciated