Un-Appending A Column Of Numbers ?

[Bob]

Hello,

Using Excel 2007.

I had a long list of numbers such as:

2001
4567
3486

which I made into:

2001MHz
4567MHz
3486MHz

By using the operation 2001&"MHz" etc.

I deleted the first list.

I would like to change the newly generated list with the MHz appended
back to solely a list of numbers, without any MHz appended to them.

How would I do this, please ?

Thanks,
Bob

 

[Pete_UK]

The quickest way would be to highlight the column, then CTRL-H (Find &
Replace), and:

Find what: MHz
Replace with: leave blank
Click Replace All.

However, if you want a formula solution which will leave you with
numeric values rather than text, you could do this:

=--SUBSTITUTE(A1,"MHz","")

and copy down, then fix the values. If you want text values then just
leave the -- off the formula.

Hope this helps.

Pete

 

[joeu2004]

The quickest way would be to highlight the column, then CTRL-H (Find &
Replace) [....]
[Or] you could do this:
=--SUBSTITUTE(A1,"MHz","")

And if you would like a single cell that __appears__ as 2001MHz, but
is actually just the number 2001, you select the cell with 2001, right-
click and click on Format > Number > Custom, and enter the Custom
format 0"MHz" .

 

[Bob]

Hi,

Much thanks.

Bob