Split a colum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have colums with following text 123jj/ref45 . The slash is there not always
I want to spilt this colum into 2 other columns 123jj in one column, and ref45 in the other column. (the slash I don't need anymore

How can I do this ? I have to do this for about 3000 rows

Thanks
Jaco
 
Hi Jaco
try the following
- select your column
- goto 'Data - Text to columns'
- choose the '/' as delimiter
- finish the wizard
 
select range (1 column at time only), Data -> Text to Columns -
Delimited -> w/ "/".

ensure blank column to right of your selection.

HT
 
Hi

Add an empty column right to one with your entries (when there isn't one
jet);
Select the column with your entries;
From menu, select Data.TextToColumn, set delimiter as Other '/', and press
OK


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


Jaco said:
Hi,

I have colums with following text 123jj/ref45 . The slash is there not always.
I want to spilt this colum into 2 other columns 123jj in one column, and
Click to expand...
ref45 in the other column. (the slash I don't need anymore)
 
Jaco

You have several answers that address your problem if the "/" mark is present,
but as you stated "the slash is there not always".

If your data without the "/" mark is consistent perhaps you could use Text to
Columns>Fixed Width and enter your own splitter manually.

Gord Dibben Excel MVP
 
Back
Top