Text to Column will not cooperate

  • Thread starter Going Crazy with excel
  • Start date
G

Going Crazy with excel

Looking to separate two names in a cell, separated by a Hyphen.
It will not separate the names.
Is there a formula that will work to separate them?
Example:
george-smith
 
T

tim m

Text to columns should (just worked in my test).

Did you do 'text to columns'...'deliminated'...click in the 'other' box and
enter the hyphen in the small window next to it. It should work that way.
 

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

Text to column where to put result 5
Separating carriage return data into separate cells 2
many numbers in one cell separated by hyphen. 6
Data separation 1
6 numbers in one column 8
Auto-Alphabetize 1
Text to Columns 4
EXCEL: Separating data from 1 cell into multiple cells 5

Top