Removing first 10 characters of text

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
 
R

Rick Rothstein

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).
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace numeric strings in larger text strings 8
Formula/Function for Counting Characters in a cell 4
removing text characters from a cell 12
Cells only display a maximum number of text characters 4
First, Last occurance of date in column 5
Extracting certain characters from a long string 4
Compare One Cell to the First 10 Characters of Another Cell 9
Extract characters from Right of string 5

Top