Text Function: Store Value instead of Reference

V

varmint

I apologize if this is a newbie question but I can't seem to find th
answer anywhere.

I am trying to clean up some data and have a column that contains 1
character ID numbers.

I only need the last 5 characters so I setup another column to get the
using =RIGHT(B2,5)

Now that I have the last 5, I don't need the original column and wan
to delete it and retain my new column. I can't though since the ne
column has a reference to the original.

How can I store the value returned from the RIGHT function instead o
the reference?

Or, is there a better way to do this such as running some function o
the original column and converting the values within it?

Thanks
 
B

Bernie Deitrick

Varmint,

1) Copy your cells with the formulas, then pastespecial values over them.
2) Use Text to columns instead, inserting a break after the 7th character,
then delete the first column.

HTH,
Bernie
MS Excel MVP
 
A

Andy B

Hi

To 'fix' your values from your formulas, copy the range and then Edit /
Paste Special / Values
 
F

Frank Kabel

Hi
copy the formula results and insert them with 'Edit - Paste Specials -
Values' to remove the formulas
 
R

RagDyeR

Select the column, then:
<Data> <TextToColumns> <FixedWidth> <Next>
Set the break line to separate the last five digits, then <Next>
Click "Do Not Import", then <Finish>.
And you now have *only* the last five digits in the column remaining!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I apologize if this is a newbie question but I can't seem to find the
answer anywhere.

I am trying to clean up some data and have a column that contains 12
character ID numbers.

I only need the last 5 characters so I setup another column to get them
using =RIGHT(B2,5)

Now that I have the last 5, I don't need the original column and want
to delete it and retain my new column. I can't though since the new
column has a reference to the original.

How can I store the value returned from the RIGHT function instead of
the reference?

Or, is there a better way to do this such as running some function on
the original column and converting the values within it?

Thanks!
 
Top