Thread: Partial copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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.