| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help to extract characters
Hi all,
I need help in excel, I have these data in the first column, TR000000ADC Display Budget TT000000A3_DC Overtime statement TU000000B4321 Display Call out time I want to make it into two columns and extract only the last few characters from the first column and make the final document look like below ADC | Display Budget A3DC | Overtime statement B4321 | Display Call out time Can anybody provide help in this regard, I want this in macro as the data is 150 rows...thanks Rgds Ajit |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract last 2 characters from the right? | Excel Worksheet Functions | |||
| Extract characters from a cell | Excel Discussion (Misc queries) | |||
| Extract the first few characters | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| Extract Characters | Excel Programming | |||
Threaded Mode
