general help

[MARYALICE]

I am working with a very long spreadsheet and need to remove the first 4 digits of each item in column A.
I there a way to do that?
All items are different except for the first 4 digits of each line are the same.

 

[BobUmlas]

Assuming they're all numbers, use a helper column (any unused column) and enter =MID(A1,5,20)*1 then fill down. Copy these values, paste special Values onto column A, then clear this column.
If they're not all numbers, remove the "*1"

 

[scottylad2]

I am working with a very long spreadsheet and need to remove the first 4 digits of each item in column A.
I there a way to do that?
All items are different except for the first 4 digits of each line are the same.

this will do it, make sure your last argument is far bigger than you're likely to need to make sure all letters in every cell pass over bar the 1st 4 digits that is

Excel Workbook
	D	E
3	mgjkope523355	ope523355
4	lkkksopee5525	sopee5525
5	235658djsjsie	58djsjsie
6	ksjrtjkd	tjkd
7	2255r8rr	r8rr
Sheet4

 

[T. Valko]

I am working with a very long spreadsheet and need to remove the first 4 digits of each item in column A.
I there a way to do that?
All items are different except for the first 4 digits of each line are the same.

One way...

Select the range of cells in question
Use Data>Text to Columns
Select the Fixed Width option
Select Next
In the Data Preview area, click between the 4th and 5th characters. This tells Excel that's where you want to split the string.
Select Next
Select Do Not Import
Select Finish