+ 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. 3rd July 2009, 09:49 AM #1
    leco
    leco is offline
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    39

    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. IDG Tech News
  3. 3rd July 2009, 10:30 AM #2
    OutToLunch
    OutToLunch is offline
    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    62
    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...

  4. 2 Thanks to OutToLunch:

    JonP (16th September 2009), leco (3rd July 2009)
  5. 3rd July 2009, 10:37 AM #3
    CESIL
    CESIL is offline

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,235
    Thank Post
    86
    Thanked 222 Times in 172 Posts
    Rep Power
    131
    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...

  6. Thanks to CESIL from:

    leco (3rd July 2009)
  7. 3rd July 2009, 10:43 AM #4
    leco
    leco is offline
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    39
    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
« processing paper cut print logger logs help | 2 File Associations »

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
  •  

Forum Rules