Split 2 words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 words I each cell, I would to put the 2nd word in a new cell, how am
I doing it?
 
Space delimited? Data>text to columns>delimited next, space as delimiter and
finish
make sure that the column to the right is empty before doing this

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Split column contents (de-concantenate) 7
VBA Multiple Line handling with Split() 1
Scrabble Value calculation for Welsh words 0
VBA set thick borders around non empty cells in range 0
Splitting Cells 4
How to split Cell content into two resulting cells 1
Splitting Text from single cell in column across multiple Columns 3

Back
Top