Text To Columns
 

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 "Whatever". 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?


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

Text To Columns
 

I'd insert a helper column to the right of your column.

Then use a formula like this:
=IF(COUNTIF(A1,"*/*")=0,"/","")&A1

Then drag this formula down the column.

Then select that new column
edit|copy
edit|paste special|values

And do data|text to columns against this helper column.

And delete the stuff you don't need when you're done.

Debrap29 wrote:

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 "Whatever". 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?

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

--

Dave Peterson