Converting a grouped number and letter to a number

[daxhughes]

I want to convert “k” to “000” when grouped with a number.

For example if I have 5k, I want it to convert to 5000 in a cell.

Each cell will need to convert a number that is grouped with k.

10k
15k
4k
100k

All these would need to convert to numbers in thousands: 10,000, 15000,4000,100,000

Thank you for the help!

 

[arthurbr]

Perhaps

=SUBSTITUTE(A9,"k","000")+0