Macro to remove first character "K" from column of numbers

Hi,

I need help creating a Macro that will remove the first character of a column on numbers when I copy and paste them to the next column. I need something that will ignore all others numbers without the letter "k" in front of them and only focus on the K numbers.
For example:

B123462
K123462 123462
K125100 125100
A125100
K129290 129290
C129291
K129292 129292
Y133707

Your help would be greatly appreciated

Data in column A, output in Column B

Please Login or Register  to view this content.

or use a formula in B column:

=IF(ISNUMBER(SEARCH("K",A1)),SUBSTITUTE(A1,"K",""),"")

.
And one other method :

Please Login or Register  to view this content.

Thank you!
My information is in column B starting in row 2 all the way down until the last number and I need the new data to go into column C starting row 2 all the way down till the last number. The program should stop after the last number as some data sets are large, while others are small. How can I modify this code to account for that?

Thanks! The formula worked