Results 1 to 8 of 8

How to separate text cell into columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-30-2007
    Posts
    125

    Question How to separate text cell into columns

    See attachment.

    When I copied my travel expenses into an Excel spreadsheet, all of the data/text was combined into column A. Is there a way or formula that can separate the traveler names, traveling date and $ amount into separate columns?

    Example.
    02/06/07 AP 018 18810 034551 0600 Domestic Travel Smith 02/02 992.30

    Objective:

    Column A Column B Column C
    Traveler Travel Date Amount
    Smith 02/02 992.30

    TIA
    Excel Newby
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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