Welcome Guest.


The interval symbols in the excel form in the Excel table are separated by the interval symbols. How to increase the number in front of the minus number when dropping and the number of numbers in front of the number remains unchanged?

Asked by: Mary Roberts 12 views Software May 14, 2022

As shown in Figure 1 to Figure 2, the "G007" increases when dropped, and the "-00" behind it remains unchanged

1 Answers

  1. +3Votes  

    = Text (ROW (Z7), “R-L-G000″) &”-00″

    Answer: = “R-L-G” &Text (ROW (Z7), “000”) &”)”

    Jason Smith- May 14, 2022 |

Answer Question