Text To Columns

D

Debrap29

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

David Biddulph

Debrap29 said:
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?
Click to expand...

Having split into 2 columns (say A and B), you could then generate
additional columns, with C having the formula
=IF(ISBLANK(B1),"",A1)
and D having the formula
=IF(ISBLANK(B1),A1,B1)

Having done that you can, if you wish, Edit/ Paste Special/ Values from your
new columns, & get rid of the intermediate ones.
 
Top