| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First 3 characters
Dear Expert,
I have used the OCR and convert the PDF file to EXCEL. BpO21Jan200810:56 C Gr 5 Oct 2008 7:58 They display in 2 types which I cannot use "Text to Column" to split all into individual columns. What functions can I use so that I can capture the 2nd characters in the cell please? What functions can I use so that I can capture the 3nd characters and the rest after the third characters please ? First one is easy ... just Left(A1,1) BpO21Jan200810:56 Then how about ? "P", "O","21Jan2008","10:56" ... C Gr 5 Oct 2008 7:58 Also, how about this ? Thanks so much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
| Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
| Selecting only some characters, using "characters property" | Excel Programming | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
