Bulk change address of excel hyperlinks?

Question

Visual Basic

There were over 5000 hyperlinks to documents in the excel workbook.
The path was something like this:
C:\Users\r67\Doc\UPD\
The files were moved to folders by month, which means that hyperlinks stopped working. Now it will look like this:
C:\Users\r67\Doc\UPD\2020\1\
C:\Users\r67\Doc\UPD\2020\2\
C:\Users\r67\Doc\UPD\2020\3 \ .....\12. How can you bulk change the address of hyperlinks, given that everything was in 1 folder, and now spread out in 12?

Answer 1

divide the column with a backslash into several
C: Users r67 Doc UPD
add two columns on the right , fill in the
first one with 2020
fill in the second one by condition, looking at the file name in the last one
, combine it
well or with a macro