VBA required to Add some Text before all Numbers

[amb2301]

Hi Friends,
i have a task to add a Text (QX) before all the numbers in K:K column & ignoring the blank cells,
Attached the sample excel file.

example: 00542123 has to be changes as QX00542123

could someone please help me to provide VBA for this task.

Thanks in Advance.

[Dante Amor]

Try this:

Please Login or Register  to view this content.

[amb2301]

Try this:

Please Login or Register  to view this content.

Thank you so much Dante Amor
As always you are so quick in reply & perfect code