| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need to remove characters ...
I have a column of data that I wish to remove the first 2 characters from.
Is there a way to quickly do this? Below is the sample data. Thank you, Rick c1122115 c1122116 c1122117 c1122118 c1122119 c1122120 c1122121 D1250592 D1250593 D1250594 D1250595 D1250596 D1250597 D1250598 |
|
#2
|
|||
|
|||
|
You could insert a column and use this formula in that cloumn and drag it
down then copy and paste values. =VALUE(MID(A1,2,8)) "Rick" wrote: I have a column of data that I wish to remove the first 2 characters from. Is there a way to quickly do this? Below is the sample data. Thank you, Rick c1122115 c1122116 c1122117 c1122118 c1122119 c1122120 c1122121 D1250592 D1250593 D1250594 D1250595 D1250596 D1250597 D1250598 |
|
#3
|
|||
|
|||
|
That did the trick, Thank You David!
"David Hepner" wrote: You could insert a column and use this formula in that cloumn and drag it down then copy and paste values. =VALUE(MID(A1,2,8)) "Rick" wrote: I have a column of data that I wish to remove the first 2 characters from. Is there a way to quickly do this? Below is the sample data. Thank you, Rick c1122115 c1122116 c1122117 c1122118 c1122119 c1122120 c1122121 D1250592 D1250593 D1250594 D1250595 D1250596 D1250597 D1250598 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Linear Mode
