Split Cells

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I am splitting a bunch of data into two cells using the
split into columns tool. The data is structure:

xxx, yyy

I use the comma as the deliminator but all my yyy data
comes out with a space in front of it. How do I get rid
of the space? I tried using the comma space as the
deliminator when splitting but it only allows a single
character. Any ideas?
 
Maybe you could select the column and
edit|replace
what: (spacebar)
with: (leave blank)
replace all

Then use data|text to columns
 
Hmmmm. What version of excel are you using?

I've never see that.

You're clicking the boxes--not typing them in the Other box, right?
 
Dave said:
Hmmmm. What version of excel are you using?
I've never see that.
You're clicking the boxes--not typing them in the Other box, right?
Click to expand...

Ditto. Are you doing a text import? It has checkboxes (not radio
buttons) for selecting delimiters, so you should be able to check
multiple delimiters.
 
Back
Top