For Joey2004 et al. From OP: Re Appending Question

[Bob]

Hello,

Thanks so much for help; really appreciate it.

Not sure how to implement what you are suggesting:

Regarding the Custom Format suggestion: O"MHz"

What is the O ? Is this a letter or number ?
What do I put for it; could you give me an example using my data, please ?

Hate to appear dumber with this than I am, but will blame it on
"old-age" now.

Much thanks,
Bob
-------------------------------------

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

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.

 

[Claus Busch]

Hi Bob,

Am Fri, 01 Mar 2013 12:31:41 -0500 schrieb Bob:

What is the O ? Is this a letter or number ?
What do I put for it; could you give me an example using my data, please ?

if you only have integers, then it is a zero
If you have decimals, then try 0,00 "MHz"


Regards
Claus Busch

 

[Bob]

Hi Claus,

Much thanks.

Might I ask one more, please:

In one of my columns, Column D, I have, e.g.,
a
b
a
a
f
g
a
w

I want to Delete any and all rows that have an "a" in Column D.

I thought I could use the Filter Command, but this doesn't seem appropriate.

What's the best way, please ?

Thanks again,
Bob

 

[Claus Busch]

Hi Bob,

Am Fri, 01 Mar 2013 13:04:12 -0500 schrieb Bob:

In one of my columns, Column D, I have, e.g.,
a
b
a
a
f
g
a
w

I want to Delete any and all rows that have an "a" in Column D.

to filter for "a" is the best way. Select the visible rows and delete
them.


Regards
Claus Busch