You could use flow to achieve this.
1.Create a single line of text column.
2.Create a flow as following picture shows.
3.Run the flow.
If an Answer is helpful, please click "Accept Answer" and upvote it
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.