LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DP7 DP7 is offline
external usenet poster
 
Posts: 54
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One partial table, one master table - update the partial boilermaker Excel Discussion (Misc queries) 3 May 28th 10 08:33 PM
.Copy partial value Bishop Excel Worksheet Functions 1 August 11th 09 07:20 PM
Find partial match from column A,B and fill partial match in C? Tacrier Excel Discussion (Misc queries) 4 October 24th 08 11:24 PM
I want to copy partial row to blank row(s) beneath it BWestly Excel Discussion (Misc queries) 1 March 17th 06 05:58 PM
Copy partial cell character format(s) from one cell to another - an example [email protected] Excel Programming 0 May 5th 05 08:23 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"