If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing first 10 characters of text
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 |
#2
|
|||
|
|||
Removing first 10 characters of text
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). -- Rick (MVP - Excel) "Scott" wrote in message ... 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 |
#3
|
|||
|
|||
Removing first 10 characters of text
Why can't you use the RIGHT function?
What's wrong with =RIGHT(A1,LEN(A1)-10) ? -- David Biddulph Scott wrote: 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 |
#4
|
|||
|
|||
Removing first 10 characters of text
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Scott" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|