+ Reply to Thread
Results 1 to 11 of 11

Convert Cell values with fixed format values

  1. #1
    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

  2. #2
    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

  3. #3
    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.

  4. #4
    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+

  5. #5
    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.

  6. #6
    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

  7. #7
    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.

  8. #8
    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..

  9. #9
    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.

  10. #10
    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.

  11. #11
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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. Replies: 2
    Last Post: 11-11-2014, 06:41 AM
  4. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1