| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove 1st 2 letters in each row
I have 30 rows and each row I need to delete the first 3 letters.
ex UNE127 UNE50 so it will be 127 50 Can someone please tell me how I can do this without going in and deleting each row. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove 1st 2 letters in each row
A simple MID might suffice
Assume your data in A2 down In B2: =MID(A2,4,99)+0 Copy down. The "+0" bit will convert the extracted text nums to real numbers. Success? hit the YES below -- Max Singapore --- "Cathy" wrote: I have 30 rows and each row I need to delete the first 3 letters. ex UNE127 UNE50 so it will be 127 50 Can someone please tell me how I can do this without going in and deleting each row. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove/Ignore Letters when Summing cells in a column. | Excel Worksheet Functions | |||
| Remove Row numbers and Column letters from a specifice workbook | Excel Worksheet Functions | |||
| Remove letters from text string | New Users to Excel | |||
| Remove dashes between letters and between letters and digits | Excel Worksheet Functions | |||
| How can I remove a space between a letters and set of numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
