Stripping out data

[Angus McBagpipe]

I have and column that reads this "8.50 (13.0)".
I would like to strip out the data into 2 columns and remove the parenthesis from the second one.

 

[alansidman]

A couple of steps in Power Query.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter("(", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Column1.2", Splitter.SplitTextByDelimiter(")", QuoteStyle.Csv), {"Column1.2.1", "Column1.2.2"}),
    #"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter1",{"Column1.2.2"})
in
    #"Removed Columns"

 

[Fluff]

How about

Book1
	A	B	C
2	8.50 (13.0)	8.50	13.0
Request

Cell Formulas
Range	Formula
B2	=LEFT(A2,FIND(" ",A2)-1)
C2	=SUBSTITUTE(MID(A2,FIND("(",A2)+1,100),")","")

 

[sandy666]

another way with PowerQuery (Get&Transform)

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Split = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByAnyDelimiter({" ("}, QuoteStyle.Csv)),
    Replace = Table.ReplaceValue(Split,")","",Replacer.ReplaceText,{"Column1.2"}),
    Type = Table.TransformColumnTypes(Replace,{{"Column1.1", type number}, {"Column1.2", type number}})
in
    Type[/SIZE]

Column1		Column1.1	Column1.2
8.50 (13.0)		8.5​	13​
10.44 (11.11)		10.44​	11.11​

 

[Angus McBagpipe]

Very cool, but this one is over my head.
Reminds me just how little I know about Excel.
But thanks and I will follow up on this with some study.

 

[Angus McBagpipe]

This is more my speed.
Thank you for replying.

Kindest regards

 

[Fluff]

You're welcome & thanks for the feedback