As I said, I would simply use TTC

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Mangesh Vimay 
Sent: Monday, September 10, 2012 9:24 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts

Hi Guillett, 

I would like to know all possible ways of cutting the string into three parts. 
So please do needful by suggesting very simple formula for same.
Thanks !!! 


On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 <dguille...@gmail.com> wrote:

  Why clutter it up by using UN necessary formulas to clutter up the file? 
Unless, of course, this is HOMEWORK

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: Mangesh Vimay 
  Sent: Monday, September 10, 2012 6:11 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three 
parts

  Yes u r right. 
  I did by using Text to Column option. Its works fine.
  But I need it by using formula.
  Thanks



  On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar <kumarmanoj.11...@gmail.com> 
wrote:

    Dear Mangesh, 

    you can use text to colum....

    Regard
    Manoj 



    On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay <mangesh.da...@gmail.com> 
wrote:

      Hi Friends, 

      I need your help to divide the string into three parts.
      The description and sample is given below :

      Waiting for your response.

      Thanks.


      -- 
      With regards, 


      MaNgEsH

      -- 
      Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
       
      FORUM RULES (1120+ members already BANNED for violation)
       
      1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
       
      2) Don't post a question in the thread of another member.
       
      3) Don't post questions regarding breaking or bypassing any security 
measure.
       
      4) Acknowledge the responses you receive, good or bad.
       
      5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
       
      6) Jobs posting is not allowed.
       
      7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
       
      NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
      --- 
      You received this message because you are subscribed to the Google Groups 
"MS EXCEL AND VBA MACROS" group.
      To post to this group, send email to excel-macros@googlegroups.com.

      To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
       
       


    -- 
    Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
     
    FORUM RULES (1120+ members already BANNED for violation)
     
    1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
     
    2) Don't post a question in the thread of another member.
     
    3) Don't post questions regarding breaking or bypassing any security 
measure.
     
    4) Acknowledge the responses you receive, good or bad.
     
    5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
     
    6) Jobs posting is not allowed.
     
    7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
     
    NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
    --- 
    You received this message because you are subscribed to the Google Groups 
"MS EXCEL AND VBA MACROS" group.
    To post to this group, send email to excel-macros@googlegroups.com.

    To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
     
     





  -- 
  With regards, 


  MaNgEsH

  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   

  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   





-- 
With regards, 


MaNgEsH

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<<image.png>>

Reply via email to