Helo good people of mrexcel forum,
Lets say I have table like this
<tbody>
</tbody>
I want to add a "prefix" (dont know if I use the correct term here) to every of the ID numbers. Lets say I want to add prefix "10". So the transformed table would look like this:
<tbody>
</tbody>
How can I do this?
EDIT: I mean of course, aside from manually typing "10" to every cell lol
Lets say I have table like this
ID | Items |
1 | Orange |
1 | Bread |
2 | Milk |
2 | Bread |
2 | Apple |
3 | Knife |
3 | Plier |
<tbody>
</tbody>
I want to add a "prefix" (dont know if I use the correct term here) to every of the ID numbers. Lets say I want to add prefix "10". So the transformed table would look like this:
ID | Items |
101 | Orange |
101 | Bread |
102 | Milk |
102 | Bread |
102 | Apple |
103 | Knife |
103 | Plier |
<tbody>
</tbody>
How can I do this?
EDIT: I mean of course, aside from manually typing "10" to every cell lol