Can somebody help me with the formula, thank you very much!Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
ADVERTISEMENT
ADVERTISEMENT
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 32345/3456 | 3456/32345 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =RIGHT(A1,LEN(A1)-FIND("/",A1,1))&"/"&LEFT(A1,FIND("/",A1,1)-1) |
source | result | |
1/3 | 3/1 | |
3/50 | 50/3 | |
56/28 | 28/56 | |
1/10 | 10/1 | |
let
Source = Excel.CurrentWorkbook(){[Name="Table15"]}[Content],
Text = Table.TransformColumnTypes(Source,{{"source", type text}}),
Split = Table.SplitColumn(Text, "source", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), {"source.1", "source.2"}),
TCC = Table.CombineColumns(Table.TransformColumnTypes(Split, {{"source.2", type text}, {"source.1", type text}}, "en-GB"),{"source.2", "source.1"},Combiner.CombineTextByDelimiter("/", QuoteStyle.None),"result")
in
TCC
did my suggestion work?
=RIGHT(A1,LEN(A1)-FIND("/",A1,1))&"/"&LEFT(A1,FIND("/",A1,1)-1)
Just tried, No it did not worked
with Power Query
I don't have power query....