View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob[_19_] Bob[_19_] is offline
external usenet poster
 
Posts: 77
Default Appending Text To Numbers ?

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.