Appending Text To Numbers ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello,

Using Excel 2007.

Have a very long column of numbers:

4
7
9
21
etc.

I want to add the following text, MHz, to each, e.g.

4MHz
7MHz
9MHz
etc.

What's the easiest way to do, please ?

Would like a method, I think, where I modify a single cell, and just
Drag it down the whole column to modify all the entries.

Thanks,
B.
 
Bob said:
Have a very long column of numbers: [....]
I want to add the following text, MHz, to each, e.g.
4MHz
7MHz
9MHz
etc.
Click to expand...

Instead of making the cell text per se, I would suggest that you simply use
a Custom format, e.g. 0"MHz" .

Thus, the cell retains in numeric value, but MHz appears in the displayed
value.

Select the cells to change their format. Or use the Format Painter tool.
 
Back
Top