Removing first 10 characters of text

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hello,

I have a list of 1,000 rows of data and I want to remove the first 10
characters from each cell. I can't use the =RIGHT function because each cell
has a different number of characters. Any ideas?

Thanks,
Scott
 
Use the MID function...

=MID(A1,10,999)

The 999 needs to be a number larger than the longest piece of text that you
anticipate (it doesn't matter if the number is larger or not).
 
Hi,

You can use either RIGHT or MID or

Select all the data in you 1000 rows, say A1:A1000 and choose Data, Text to
Columns, Fixed Width, Next. In the Preview pane click between the 10th and
11th characters - this will put in a line/arrow. Click Next. Select the 1st
column in the Preview pane and choose Do Not Import (Skip). Click Finish.
 
Back
Top