I have a worksheet which includes a column that has anywhere from 6-14 digits. After data is entered for this project I need to copy the digits from excel to a notepad. Please see how the format should read in notepad below.

I found a way to format adding the single quote and comma but not the carriage return. Is there a simple formula for this?

EXCEL

728474
1002208755
1001873448
783715
791490


Notepad

('728474','1002208755','2018551436','1001873448','783715','791490')