Un-Appending A Column Of Numbers ?

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

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
 
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
 
The quickest way would be to highlight the column, then CTRL-H (Find &
Replace) [....]
[Or] you could do this:
=--SUBSTITUTE(A1,"MHz","")
Click to expand...

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" .
 
Back
Top