+ Reply to Thread
Results 1 to 11 of 11

Convert Cell values with fixed format values

  1. 03-22-2016, 03:12 AM #1
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Convert Cell values with fixed format values

    Hello Friendz,

    Need Vba to convert Cell values with fixed format as shown in file.. Please assist as to how can I do this.. thank you
    Last edited by Parth007; 03-23-2016 at 08:39 AM.
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  2. 03-22-2016, 08:50 AM #2
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Can this be achieved with formula or VBA will do for this.. please assist
    Reply With QuoteRegister To Reply
  3. 03-22-2016, 08:15 PM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,387

    Re: Convert Cell values with fixed format values 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-23-2016, 04:57 AM #4
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Simply Superb Great work.. thank you so much Jindon.... it actually saved my time.. total rows were 5000+
    Reply With QuoteRegister To Reply
  5. 03-23-2016, 05:04 AM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,387

    Re: Convert Cell values with fixed format values

    Quote Originally Posted by Parth007 View Post
    it actually saved my time.. total rows were 5000+ 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 03-23-2016, 05:47 AM #6
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Hi Jindon.. I see there are one more data difference..

    Input-
    1) ATS REX 2) BIP TI 3) CAT TOE

    Xas Tgu, Yie TT, Z R

    Ouptup Should be -

    Input-
    1) ATS REX
    2) BIP TI
    3) CAT TOE

    1)Xas Tgu,
    2)Yie TT,
    3)Z R




    Please assist for both values
    Reply With QuoteRegister To Reply
  7. 03-23-2016, 05:51 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,387

    Re: Convert Cell values with fixed format values

    You should upload a workbook with all the possible combination data and the result that you want.
    Reply With QuoteRegister To Reply
  8. 03-23-2016, 05:54 AM #8
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Hi Jindon... in all data the above was one unique which I missed to specify in file....

    Your code covered everything except this which I missed

    I went through all data..
    Reply With QuoteRegister To Reply
  9. 03-23-2016, 07:06 AM #9
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Hi Jindon.. Please see the file with all possible combinations...
    Last edited by Parth007; 03-23-2016 at 08:38 AM.
    Reply With QuoteRegister To Reply
  10. 03-23-2016, 07:39 AM #10
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,387

    Re: Convert Cell values with fixed format values

    For the data provided.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 03-23-2016, 08:38 AM #11
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    876

    Re: Convert Cell values with fixed format values

    Bang Bang... that's was more than perfect one... thank a lot Jindon !!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 'Format all cells based on their values', using values outside of the cell
    By OllieRaiden in forum Excel General
    Replies: 4
    Last Post: 07-27-2015, 02:21 AM
  2. how to change one Cell values to number of Rows with fixed Header
    By tanwar123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2015, 02:39 AM
  3. Subtracttion from a fixed cell Using Horizontal Values and Results in Vertical Cells
    By angirasv in forum Excel General
    Replies: 2
    Last Post: 11-11-2014, 06:41 AM
  4. Formula to find average of values between negative values in 'random' array of fixed size
    By zorba457773434 in forum Excel General
    Replies: 13
    Last Post: 10-08-2014, 08:35 AM
  5. Convert Text Values to Specific Numeric Values
    By lmp101010 in forum Excel General
    Replies: 5
    Last Post: 09-06-2014, 04:00 PM
  6. Need a Macro program to push values against fixed reference values in different columns
    By Varhead in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 09:06 AM
  7. [SOLVED] Macro to loop through cell values in a column and format multiple cell values
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 05:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1