Format a Vehical no .

[Anmo_net]

How to format this Vehical no in excel cko8cg5677 to this CKO8-CG-5677 reflect into Entire row?

 

[vletm]

Anmo_net
=UPPER(LEFT(B3,4) & "-" & MID(B3,6,2) & "-" & RIGHT(B3,4))
or upload a sample Excel file with expected results.

 

[Anmo_net]

It's working ... How to reflect formulas result on same cell when pressing enter and also how to use this formula on entire column?

 

[Peter Bartholomew]

The second part of the question requires copy down or an array reference rather than a cell reference

= UPPER(
      LEFT(rawdata,4)
         & "-"
         & MID(rawdata,5,2)
         & "-"
         & RIGHT(rawdata,4)
   )

which will spill to return the entire range of results using modern Excel (365 or 2021) but requires CSE for legacy systems.
As for changing the result in the same cell, that violates the principles of functional programming and is not supported.
If you wish to use VBA, being procedural code, that can overwrite the input data but care is needed to avoid an endless loop of changing the same cells.

 

[vletm]

Anmo_net
As written
or upload a sample Excel file with expected results.

 

[pecoflyer]

This is my first go at Power Query
Please let me know what can be done better

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Uppercased Text" = Table.TransformColumns(#"Changed Type",{{"Column1", Text.Upper, type text}}),
#"Split Column by Position" = Table.SplitColumn(#"Uppercased Text", "Column1", Splitter.SplitTextByPositions({0, 4}, false), {"Column1.1", "Column1.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Position",{{"Column1.1", type text}, {"Column1.2", type text}}),
#"Split Column by Position1" = Table.SplitColumn(#"Changed Type1", "Column1.2", Splitter.SplitTextByPositions({0, 4}, true), {"Column1.2.1", "Column1.2.2"}),
#"Merged Columns" = Table.CombineColumns(#"Split Column by Position1",{"Column1.1", "Column1.2.1", "Column1.2.2"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Merged")
in
#"Merged Columns"