Split Cells

[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?

 

[Dave Peterson]

Maybe you could select the column and
edit|replace
what: (spacebar)
with: (leave blank)
replace all

Then use data|text to columns

 

[Dave Peterson]

Or just use both space AND comma as delimiters. (That's easier!)

 

[Ian]

It would only let me use one character for delmiters
(either space or comma)

 

[Dave Peterson]

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?

 

[Bucky]

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?

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.