I am trying to concatenation two cells together with a character between them, for multiple rows, in order to create part numbers in my spreadsheet.
1A with / and 1 to create the result 1A/1 for example.
In order to replace the calculated value in place of the formula used, you can select F9.
This works on each set of cells you have applied this function to.
How can you apply the effect of the F9 function as part of the formula for a large number of following rows?