How to delete fist 6 digit of all contents in a column?
Column has 13 digits(alpha-numeric) and we need to delete the first 6 of
each cell in the same column (D1 to D500)
--
capxc

=Right(A1,LEN(A1)-6)

How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)

presume E is a column of blank cells, go to E1 and insert the formula:
=Right(D1,LEN(D1)-6)
then copy down

You don't. You do it as follows:

1. Insert a helper column, typically right next to the current one (so it
will be column E).
2. Insert the formula given in E1, and copy it down. The easiest way to copy
it down is double click on the fill handle (bottom right hand cornet of the
box).
3. Copy the column (highlight the top box with the E in it, right click and
choose Copy).
4. Paste SpecialValues... (Right click anywhere in the column, choose Paste
Special... Chose Values).
5. Delete the old column.

Regards,
Fred.

"capxc" wrote in message
...
How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)

Capxc

If you wanted a little bit of Visual basic code, you could achieve the same
result without any helper columns with the following:

Sub TrimFirstSix()
For Each TrimCell In Range("D1:D500")
TrimCell.Formula = Right(TrimCell, Len(TrimCell) - 6)
Next
End Sub

If you wanted to select a range of cells and trim THOSE, replace the second
line with: For Each TrimCell In selection

Regards

Pete


"capxc" wrote:

How to delete fist 6 digit of all contents in a column?
Column has 13 digits(alpha-numeric) and we need to delete the first 6 of
each cell in the same column (D1 to D500)
--
capxc

Formula is succesful but when Idelete the old column, the new column shows
only
#VALUE!
How do I get to see the numbers?
--
capxc


"Fred Smith" wrote:

You don't. You do it as follows:

1. Insert a helper column, typically right next to the current one (so it
will be column E).
2. Insert the formula given in E1, and copy it down. The easiest way to copy
it down is double click on the fill handle (bottom right hand cornet of the
box).
3. Copy the column (highlight the top box with the E in it, right click and
choose Copy).
4. Paste SpecialValues... (Right click anywhere in the column, choose Paste
Special... Chose Values).
5. Delete the old column.

Regards,
Fred.

"capxc" wrote in message
...
How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)

Before you delete the old copy all new and paste special as values in place,
then delete the old

--


Regards,


Peo Sjoblom

"capxc" wrote in message
...
Formula is succesful but when Idelete the old column, the new column shows
only
#VALUE!
How do I get to see the numbers?
--
capxc


"Fred Smith" wrote:

You don't. You do it as follows:

1. Insert a helper column, typically right next to the current one (so it
will be column E).
2. Insert the formula given in E1, and copy it down. The easiest way to
copy
it down is double click on the fill handle (bottom right hand cornet of
the
box).
3. Copy the column (highlight the top box with the E in it, right click
and
choose Copy).
4. Paste SpecialValues... (Right click anywhere in the column, choose
Paste
Special... Chose Values).
5. Delete the old column.

Regards,
Fred.

"capxc" wrote in message
...
How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)

Never mind my last question. I fugure it out.
Thanks.
--
capxc


"Fred Smith" wrote:

You don't. You do it as follows:

1. Insert a helper column, typically right next to the current one (so it
will be column E).
2. Insert the formula given in E1, and copy it down. The easiest way to copy
it down is double click on the fill handle (bottom right hand cornet of the
box).
3. Copy the column (highlight the top box with the E in it, right click and
choose Copy).
4. Paste SpecialValues... (Right click anywhere in the column, choose Paste
Special... Chose Values).
5. Delete the old column.

Regards,
Fred.

"capxc" wrote in message
...
How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)