| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Partial copy
Hi I want to know if I can copy & paste ONLY the 4th 5th and 6th characters
in a text string. Also we need to start counting from the RIGHT. I know u can use the right and left functions. But in this case is will need only the 4th,5th & 6th. E.g. 224F74 In the case the ans. Should be 224. 6228E73 In the case the ans. Should be 288. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Partial copy
Copy is an all or nothing proposition so no cay can not just copy a few
characters. You can however use a formula similar to this to get the appropriate characters... =MID(A1, LEN(A1)-5, 3) -- HTH... Jim Thomlinson "DP7" wrote: Hi I want to know if I can copy & paste ONLY the 4th 5th and 6th characters in a text string. Also we need to start counting from the RIGHT. I know u can use the right and left functions. But in this case is will need only the 4th,5th & 6th. E.g. 224F74 In the case the ans. Should be 224. 6228E73 In the case the ans. Should be 288. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Partial copy
Try this:
LEFT(RIGHT(MyString,6),3) "DP7" wrote: Hi I want to know if I can copy & paste ONLY the 4th 5th and 6th characters in a text string. Also we need to start counting from the RIGHT. I know u can use the right and left functions. But in this case is will need only the 4th,5th & 6th. E.g. 224F74 In the case the ans. Should be 224. 6228E73 In the case the ans. Should be 288. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One partial table, one master table - update the partial | Excel Discussion (Misc queries) | |||
| .Copy partial value | Excel Worksheet Functions | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| I want to copy partial row to blank row(s) beneath it | Excel Discussion (Misc queries) | |||
| Copy partial cell character format(s) from one cell to another - an example | Excel Programming | |||
Linear Mode
