Split a colum

[Jaco]

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

 

[Frank Kabel]

Hi Jaco
try the following
- select your column
- goto 'Data - Text to columns'
- choose the '/' as delimiter
- finish the wizard

 

[firefytr]

select range (1 column at time only), Data -> Text to Columns -
Delimited -> w/ "/".

ensure blank column to right of your selection.

HT

 

[Arvi Laanemets]

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

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)

 

[Gord Dibben]

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