Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

excel VBA code to split data to more cells


  • Please log in to reply

#1
fdatema

fdatema

    New Member

  • Member
  • Pip
  • 1 posts
I am just starting to have a look into macro's. My first objective is to split the names of my contacts into 2 cells such as to create a column with only the first name and one with the surname, i.e.

Split the contact info John Doe into one cell containing John and the next one containing Doe.

I would like to write a macro for this but don't know if there is a code to split the data in a cell by recognising the free space between first and surname.

Thanks,

Frits
  • 0

Advertisements


#2
jasonharrod

jasonharrod

    Member

  • Member
  • PipPip
  • 18 posts
The best solution to this problem is to start recording a macro, do a text-to-column using a space to separte them. then stop recording the macro and go and look inside the macro code using edit. Hope this helps.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP