Sorted by: -2. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Joined. [instance_num]; defines the number of occurrences in old_text you want to substitute. 2. The line spacing is shown in multiples. Tags: FIND FunctionIFERROR FunctionINDIRECT FunctionLEN FunctionMAX FunctionMIN FunctionREPLACE FunctionROW FunctionSpace in ExcelSUBSTITUTE FunctionTRIM Function. In the top menu select Vertical Align and then select Middle. If you want numerical spacing on the X-axis you MUST use the XY Scatter plot. If you want to add extra spacing between your text and the top and bottom cell borders, you can also do this from within the Format Cells options box. Then select, Then, with the text still selected (or select all of the text again), right-click once again and select. [instance_num]; defines the number of occurrences in old_text you want to substitute. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge. //