+ Reply to Thread
Results 1 to 4 of 4

Formual require for formatting the text columns.

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    18

    Formual require for formatting the text columns.

    Hi,

    Please find the attachment.

    I have prapared a formula for B2,B3 and C2,C3 and the reult came in B10,B11,C10,C11 and D10,D11,E10,E11.

    From that relust i want to get the final result should be as follows.

    B10 should again divided in to anil(in one cell) and 16/12/2013 11:33:50 (in another cell). This formula to be added in B10,B11,C10,C11 and D10,D11,E10,E11 formula.

    I loooking for the final reslt, i have explain the in the excel. I reuired the final result with single formula from B2,B3 and C2,C3.

    Please try to right a formula becuase i am not good in macros.

    Thanks in advance.

    Regards
    Kasi
    Attached Files Attached Files
    Last edited by Fotis1991; 12-31-2013 at 06:09 AM.

  2. #2
    Forum Contributor Bhuvi's Avatar
    Join Date
    04-19-2013
    Location
    Delhi, India
    MS-Off Ver
    MS Excel 2003,07,10
    Posts
    153

    Re: Formual require for formatting the text columns.

    Hi Kasi,

    You can use the formula in rows 19 and 20 in the attached sheet.




    <if this helped, please click on the Star * below this post to add some reputation>
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    18

    Thumbs up Re: Formual require for formatting the text columns.



    Thanks it works.

  4. #4
    Forum Contributor Bhuvi's Avatar
    Join Date
    04-19-2013
    Location
    Delhi, India
    MS-Off Ver
    MS Excel 2003,07,10
    Posts
    153

    Re: Formual require for formatting the text columns.

    Please mark this thread as solved from thread tools sub menu.
    If this helped and you wish to say thanks, then Please click on the Star* icon below this post.

+ 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. Comparing Columns for a logic test
    By OkSo... in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2013, 11:53 AM
  2. Pull sub-test scores from test w/best overall test score (PSAT)
    By PowerSchoolDude in forum Excel General
    Replies: 0
    Last Post: 11-19-2009, 08:29 PM
  3. Vlookup test against 2 columns
    By RxMiller in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-22-2009, 05:44 PM
  4. Need to test for multiple variables in columns
    By donoisbono in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2007, 03:18 PM
  5. Sum one column after capmaring test from teo more columns
    By Ashfaq in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2005, 11:06 AM

Tags for this Thread

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