Results 1 to 8 of 8

Excel Question - TExt to Column delemma

Threaded View

  1. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,111

    Re: Excel Question - TExt to Column delemma

    so that worked - apart from 1 row
    Iron Maiden 2013-06-05 Paris

    which does not have the - between the name and date

    see attached

    once done

    I would then copy the range B1 to D??
    copy
    paste special
    Value
    so then the formulas are replaced and you have text to do what you like with
    and can delete column A with no effect
    Attached Files Attached Files
    Last edited by etaf; 06-21-2013 at 04:20 PM.

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