Results 1 to 2 of 2

Text to collumn

Threaded View

  1. 03-12-2014, 01:32 AM #1
    amit.roy997
    amit.roy997 is offline
    Registered User
    Join Date
    12-07-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Text to collumn

    Hi,

    I have a very simple problem but can't solve so please help me.

    Problem:
    In cell A1:31.01.2014
    I want B1 should be 31, C1 should be 01 and D1 should be E1
    By formula not using text to Collumn shortcut in excel.

    Regards,
    Amit Kumar Roy
    Last edited by amit.roy997; 03-12-2014 at 01:49 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Find a collumn in a dynamic sheet and select the entire collumn
    By Armand0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 11:20 AM
  2. if two conditions are met , can I return a text message in another collumn?
    By tzahranul in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 06-22-2012, 03:16 AM
  3. [SOLVED] if two conditions are met , can I return a text message in another collumn?
    By tzahranul in forum Excel General
    Replies: 2
    Last Post: 06-21-2012, 05:12 PM
  4. Lookup according to text found in separate collumn
    By Adam Beauregard in forum Excel General
    Replies: 0
    Last Post: 03-27-2012, 02:28 PM
  5. looking for a value in a collumn
    By exceluser2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2006, 07:53 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