I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.

C1 your number
D1=left(c1,5)
best wishes
sreedhar

"ManhattanRebel" wrote:

I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.

Try this:

=Left(A1,5)
And copy down as needed.

OR
=--Left(A1,5)
To make the values true numbers.

OR
Select the column of numbers, then, from the Menu Bar,
<Data <Text To Columns
Click on "Fixed Width", then <Next

Move the "Break Lines" to where you need them,
Then <Finish.
--

HTH,

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

"ManhattanRebel" wrote in message
...
I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.

Thank you, I appreciate the help.

"RagDyeR" wrote:

Try this:

=Left(A1,5)
And copy down as needed.

OR
=--Left(A1,5)
To make the values true numbers.

OR
Select the column of numbers, then, from the Menu Bar,
<Data <Text To Columns
Click on "Fixed Width", then <Next

Move the "Break Lines" to where you need them,
Then <Finish.
--

HTH,

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

"ManhattanRebel" wrote in message
...
I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.

You're welcome and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ManhattanRebel" wrote in message
...
Thank you, I appreciate the help.

"RagDyeR" wrote:

Try this:

=Left(A1,5)
And copy down as needed.

OR
=--Left(A1,5)
To make the values true numbers.

OR
Select the column of numbers, then, from the Menu Bar,
<Data <Text To Columns
Click on "Fixed Width", then <Next

Move the "Break Lines" to where you need them,
Then <Finish.
--

HTH,

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

"ManhattanRebel" wrote in
message
...
I have 9 numeric characters in a cell and I need to get rid of the last
4.
How can I do that. There are too many cells to manually delete.