EXPAND Function Explained
The EXPAND function in Microsoft Excel is used to convert a text string that contains a number in scientific notation to a number. It takes two arguments: the text string and the number of decimal places to which you want to expand the number. The function returns the number in decimal form.
EXPAND Function Syntax
EXPAND(text, [characters], [lines], [auto_fit])
- text: The text string to expand.
- characters: (Optional) The number of characters to expand the text string by.
- lines: (Optional) The number of lines to expand the text string by.
- auto_fit: (Optional) A Boolean value that specifies whether to automatically adjust the column width to fit the contents.