Text To Columns
 

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.


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

Text To Columns
 

Debrap29,

To add the "/" at the beginning when it is not found you could use
this.

=IF(ISNUMBER(FIND("/",A1,1)),A1,"/"&A1)

Copy down as needed. Then copy the result of your formulas and Paste
SpecialValues over your new text. Then you can use Text to Columns
with the "/" as the delimiter.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=559006

Text To Columns
 

Debrap29,

To add the "/" at the beginning when it is not found you could use
this.

=IF(ISNUMBER(FIND("/",A1,1)),A1,"/"&A1)

Copy down as needed. Then copy the result of your formulas and Paste
SpecialValues over your new text. Then you can use Text to Columns
with the "/" as the delimiter.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=559006

Text To Columns
 

Thanks Steve...that worked perfectly!!!


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

Text To Columns
 

You're welcome and thanks for the feedback.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=559006