mattdaddy.net info that bounces inside my brain that makes sense to me, maybe you.

18Jul/080

Excel help – separating name into two columns

I had a need to take one column with a persons name and separate it out into a first name and a last name column.  Rather than cut and paste everything, I googled for a formula and after about 15 min, found it:

http://www.bluemoosetech.com/microsoft-excel-functions.php?jid=32&title=Separating%20First%20and%20Last%20Names%20in%20Microsoft%20Excel

hope it helps anyone who is looking for it.

Filed under: geeking out, Uncategorized Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

» «

Pages

What I'm Doing...

  • Looking for a template for a financial/investment data model. Still learning about the industry, want to start playing with some stuff. 10 hrs ago
  • Anyone know where I can find an Eagle/Pace Investment Systems consultant or consulting company? 3 days ago
  • #sqlhelp nevermind, helps if you look in the connection itself to see the query :) 4 days ago
  • #sqlhelp - I have a query I'd like to save to excel and have it refresh everytime someone runs it. Am I missing something? 4 days ago
  • just getting started in the financial industry. Any advice on getting a Data model for a securities db? I'm still learning what a call is! 1 week ago
  • Anyone see Avengers? Can't believe I couldn't see it this weekend. 2 weeks ago
  • want to download sql 2012, is there a dev version? Want to build prototype for work to convince them to upgrade. #sqlhelp 2 weeks ago
  • Ah. where not (a1.country = 'US' and b1.country = 'US' and c1.country = 'US') #sqlhelp Thanks Mike! 2 weeks ago
  • where (a.1 <> 'US' and b.1 <> 'US' and c.1 <> 'US') isn't working. #sqlhelp 2/2 2 weeks ago
  • where (a.1 <> 'US' and b.1 <> 'US' and c.1 <> 'US') isn't working. 2 weeks ago
  • More updates...

Posting tweet...

Powered by Twitter Tools