+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Excel formula? in Technical; Having a mental block here - must be something to do with the heat! I have a list of "surname ...
  1. #1
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    41

    Excel formula?

    Having a mental block here - must be something to do with the heat!

    I have a list of "surname space forename" in one column. I need to separate them into two columns - how do I detect the space in order to capture each part, to place in separate columns?

  2. #2

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Do you need a formula? You can just select the column then use the menu Data -> Text to Columns and tell it it's delimited by a space...

  3. 2 Thanks to OutToLunch:

    JonP (16th September 2009), leco (3rd July 2009)

  4. #3

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    Old skool way would be two formulas...first grabs left of cell up to position of space and second right from position of space...

    ...but nowadays as OutToLunch said use text to columns...

  5. Thanks to CESIL from:

    leco (3rd July 2009)

  6. #4
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    41
    I said I was having a blank - thanks both, the suggestion will of course do the job.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Excel Nested IF formula
    By park_bench in forum Office Software
    Replies: 11
    Last Post: 8th May 2009, 04:24 PM
  2. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 03:34 PM
  3. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  4. Excel Question / Formula Needed
    By timbo343 in forum How do you do....it?
    Replies: 22
    Last Post: 4th August 2008, 09:06 PM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •