Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pulling characters out of a string
I have a column with numbers that are either 3 or 4 characters in length. I
would Like to delete just the last two characters. Is there an easy way to do this? Thanks |
#2
|
|||
|
|||
Hi Patrick
so if you have 123 1234 you want 1 and 12 if so then in a column next to your data enter =LEFT(A1,LEN(A1)-2) (where A1 is the first value of the orginal data) and fill down - move cursor over bottom right of cell until you see a + then double click if you want to get rid of the original numbers, select this new column & copy it, click on the first cell of the old numbers and choose edit / paste special - values Hope this helps Cheers JulieD "Patrick" wrote in message ... I have a column with numbers that are either 3 or 4 characters in length. I would Like to delete just the last two characters. Is there an easy way to do this? Thanks |
#3
|
|||
|
|||
Hi
=LEFT(A1,LEN(A1)-2) -- Regards Frank Kabel Frankfurt, Germany "Patrick" schrieb im Newsbeitrag ... I have a column with numbers that are either 3 or 4 characters in length. I would Like to delete just the last two characters. Is there an easy way to do this? Thanks |
#4
|
|||
|
|||
If you use a Helper Column, you can do the Formula below. Then Copy the
Results and use Edit Paste Special to get the Values. then delete the original data, if necessary. =IF(LEN(A1)=4,LEFT(A1,2),LEFT(A1,1)) If you are doing this with numbers, you may want to use a slight variation: =VALUE(IF(LEN(A1)=4,LEFT(A1,2),LEFT(A1,1))) tj "Patrick" wrote: I have a column with numbers that are either 3 or 4 characters in length. I would Like to delete just the last two characters. Is there an easy way to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
255 characters in a cell | Excel Discussion (Misc queries) | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
#### error if cell has more than 255 characters | Excel Discussion (Misc queries) | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Add a string to a cell | Excel Worksheet Functions |