Add some word to all or some rows in Excel

Question

If I want to add some words before each number of a column, how can I do that?

10 s 123

24 c 235

33 s 345

46 s 346

59 s 546

62 c 277

I mean: for example, I put the word "k" before each number in the first column and get

k10 s 123

k24 c 235

k33 s 345

k46 s 346

k59 s 546

k62 c 277

Answer 1

• Select All cells that want to change.
• Right click and select Format cell.
• In the category select Custom.
• In Type select General and insert this formol ----> "k"@

I hope this helps you.