Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
I want to eliminate the first character in several lines, but leave the
remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
If all are six characters long and in Col A then enter this in B1 and copy down
=RIGHT(A1,5) if they are of different lenght then use =RIGHT(A1,LEN(A1)-1) "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
try
=MID(A2,2,5) this assume that you always have 6 characters and you want the last 5 -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
Worked like a charm - only thing I had to do was to copy and paste my numbers
up one row, as they all shifted down one by having to put the formula in. I do happen to have numbers of all different length, so thanks for including that info. I would have never came up with that, as I am only a casual user, so THANK YOU!!! "Sheeloo" wrote: If all are six characters long and in Col A then enter this in B1 and copy down =RIGHT(A1,5) if they are of different lenght then use =RIGHT(A1,LEN(A1)-1) "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
I didn't try this, as I have differing numbers of characters, but thanks
anyway!!! The previous post got me to where I needed to be - but thanks for taking the time! "francis" wrote: try =MID(A2,2,5) this assume that you always have 6 characters and you want the last 5 -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
You are most welcome...
everyone starts as a novice... the joy of Excel (and other software) is that you discover new and better ways to do things even after years of using it... "ccdhofer" wrote: Worked like a charm - only thing I had to do was to copy and paste my numbers up one row, as they all shifted down one by having to put the formula in. I do happen to have numbers of all different length, so thanks for including that info. I would have never came up with that, as I am only a casual user, so THANK YOU!!! "Sheeloo" wrote: If all are six characters long and in Col A then enter this in B1 and copy down =RIGHT(A1,5) if they are of different lenght then use =RIGHT(A1,LEN(A1)-1) "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
Hi
Thanks for the feedback. if you do have different length of characters and want to return from the 2nd characters onward, try =MID(A2,2,LEN(A2)) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I didn't try this, as I have differing numbers of characters, but thanks anyway!!! The previous post got me to where I needed to be - but thanks for taking the time! "francis" wrote: try =MID(A2,2,5) this assume that you always have 6 characters and you want the last 5 -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to eliminate the first character in several lines
Third parameter in MID is no. of characters to be extracted and not the
position of the last character... so it should be =MID(A2,2,LEN(A2)-1) to exclude the first character... "francis" wrote: Hi Thanks for the feedback. if you do have different length of characters and want to return from the 2nd characters onward, try =MID(A2,2,LEN(A2)) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I didn't try this, as I have differing numbers of characters, but thanks anyway!!! The previous post got me to where I needed to be - but thanks for taking the time! "francis" wrote: try =MID(A2,2,5) this assume that you always have 6 characters and you want the last 5 -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked I am an ordinary user trying to assist another Thank You cheers, francis "ccdhofer" wrote: I want to eliminate the first character in several lines, but leave the remaining characters. For instance, I use Excel as a "log book" and I have a column that contains chronological numbers that, currently all begin with the letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the "S", but leave the remaining four digit number, with ending letter intact. Considering my log bog is nearly 13500 lines long, I want to find a quick way to do this. I am thinking of using Find and Replace, somehow, but cannot figure out how to do, without completely clearing the cell. I am using Excel 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate grid lines in an EXCEL Surface chart? | Charts and Charting in Excel | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
how can I eliminate the last character of a cell? | Excel Discussion (Misc queries) | |||
Embedded status lines should eliminate annoying popup "OK"windows | Setting up and Configuration of Excel | |||
How to permanently eliminate shadow as default for chart lines? | Charts and Charting in Excel |