-
编辑 删除
合并文本字符串
concatenate 函数可以用来合并几个单元格内的文本字符。EX:=concatenate(A1,A2)
-
编辑 删除
Excel define List name and data Validation
1. define a list in the excel, choose the cell range and right click to choose 'define name', then a list is created.2. click on the cell, data panel , choose validation , then source in...
-
编辑 删除
Testing Cubes in BI Projects using Excel
Recently, am involved in the BI projects testing activities. Basically, the main task is the data comparison between data in database(Source data) and the data out of our cubes (Target data). &n...
-
编辑 删除
Format data with fixed decimals in excel
Round function returns a number rounded to a specified number of digits. Example: Round(7.3333, 2) = 7.33
-
编辑 删除
Remove spaces inside the Cell in Excel
Trim The Trim function returns a text value with the leading and trailing spaces removed.Example: = Trim (A1) SubstituteSubstitute function replaces a set of characters with another. ...
