Hi All:

I am having a problem with "Text to Columns". I have a column which
includes information which is separated by "/". However, the "/" is not
included in every row of the column. i.e. 1 row in the column contains
"ADMIN1/232322" and that's easy to make into two columns, however in
row 2 I have "232322". This information goes into the left column where
"ADMIN1" would be, but I need it to go into the right column where
"232322" would be.
Is there a way of me getting this information into the correct column?

I guess another question I have is maybe I can write an if then
statement to add "/" to those cells which don't have them currently so
that way I can split the columns up easily.
However, I want to write this in VBA to do this for two columns, not
just one cell at a time.


--
Debrap29
------------------------------------------------------------------------
Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127
View this thread: http://www.excelforum.com/showthread...hreadid=559284

You have a suggestion at your first post.

Debrap29 wrote:

Hi All:

I am having a problem with "Text to Columns". I have a column which
includes information which is separated by "/". However, the "/" is not
included in every row of the column. i.e. 1 row in the column contains
"ADMIN1/232322" and that's easy to make into two columns, however in
row 2 I have "232322". This information goes into the left column where
"ADMIN1" would be, but I need it to go into the right column where
"232322" would be.
Is there a way of me getting this information into the correct column?

I guess another question I have is maybe I can write an if then
statement to add "/" to those cells which don't have them currently so
that way I can split the columns up easily.
However, I want to write this in VBA to do this for two columns, not
just one cell at a time.

--
Debrap29
------------------------------------------------------------------------
Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127
View this thread: http://www.excelforum.com/showthread...hreadid=559284

--

Dave Peterson