Partial copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing external data on individual sheets in a specific sequen 1
Userform comobox equal to first 3 digits in a cell 4
Re training expiry date formula required 3
TEXT (searching for a character) 3
Extract string after specific characters 7
need formula for average of rolling 4 rows in excel document 1
Help Plese. 2
Is there a limit on # of radio buttons 8

Back
Top