New Formula Idea

[Qtipsam]

Can someone provide another formula idea to combine to two columns together? I would need the final result to be 060-MIL. I normally use the formula shown, but wondering if there is an easier one. Thank you.

 

[AlanSidman]

With Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Merged Columns" = Table.CombineColumns(Source,{"Pricing Type", "Customer Group"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Combo")
in
    #"Merged Columns"

Pricing Type	Customer Group	Combo
060	MIL	060 MIL
060	SHL	060 SHL
060	ZOO	060 ZOO

 

[p45cal]

but wondering if there is an easier one

Yours is pretty easy but:

 

[Peter Bartholomew]

Probably the simplest is the dynamic array version of the OP formula

= pricingType & "-" & customerGroup

My favourite would be @pascal's Combo4 solution. Maybe taking it a step further to using a named lambda function in place of the inbuilt function TEXTJOIN

= BYROW(descriptors, TextJoinλ)

where

TextJoinλ
=LAMBDA(a, TEXTJOIN("-", , a))

 

[bosco_yip]

You need the final result to be 060-MIL

Then, try this simply formula in cell C2, copied down:

=TEXT(A2,"000-")&B2