A column of figures with kg are g and text type, how to kg into g,
4.5 kg how into 4500 g, for example, some more data, by the way, I use the 2010 version

CodePudding user response:

Process cumbersome, but can help you to understand well,

CodePudding user response:

Use find replace button, modify the selected column, will be replaced by 000 K, (open options, don't choose case-sensitive, search by column)
Artificial in removing redundant 0
Blank. (point) to replace
G G replace
Give it a try!

CodePudding user response:

Coming to separate units, then use formula conversion to merge,=A1 * 1000 & amp; B1

CodePudding user response:

Remember to give points
Name=value (division) * 1000 & amp;" G, "

Take no thank you,

CodePudding user response:

The key is you need to direct change in the original place, still can add a new column, if the column, the former can be selected to modify will be replaced by 000 K, if you can add a list of auxiliary column, then you can=value (A1) * 1000 & amp;" g"