c.Value = _
WorksheetFunction.Replace(c.Text, 1, 5, "")

You can also use VB's built in Mid function to do that as well...

c.Value = Mid(c.Text, 6)

where the 6 is one more than the number of beginning characters that are to
be removed.

--
Rick (MVP - Excel)


"Ron Rosenfeld" wrote in message
...
On Sat, 11 Apr 2009 19:36:01 -0700, dstiefe

wrote:

I have values in a cell

A3452.79%

I need to delete the first 5 characters from the cell.

how do i do that?

Thank you

The Replace *worksheet function* does that. Since you posted in a
programming
group, I will suggest a VBA macro.

To enter this Macro (Sub), <alt-F11 opens the Visual Basic Editor.
Ensure your project is highlighted in the Project Explorer window.
Then, from the top menu, select Insert/Module and
paste the code below into the window that opens.

To use this Macro (Sub), first select a range to process.

Then <alt-F8 opens the macro dialog box. Select the macro by name, and
<RUN.

================================
Sub Rem5()
Dim c As Range, Rng As Range
Set Rng = Selection 'or whatever

For Each c In Rng
If Len(c.Text) 5 Then
c.Value = _
WorksheetFunction.Replace(c.Text, 1, 5, "")
End If
Next c
End Sub
================================
--ron