String manipulation

[Guest]

Hi

I have a list of codes in a column. These codes are in the form of a number of any length followed by a '/' followed by another number of any length

I want to extract the number up to the '/' and insert it into the adjacent cel

Any help much appreciate

Thanks, Greg

 

[Harald Staff]

Hi Greg

Menu Data > Text to columns, select / as separator.

--
HTH. Best wishes Harald
Followup to newsgroup only please

Hi,

I have a list of codes in a column. These codes are in the form of a

number of any length followed by a '/' followed by another number of any
length.

 

[Tom Ogilvy]

ActiveCell.Offset(0,1).Value = Left(ActiveCell,instr(ActiveCell,"/")-1)

--
Regards,
Tom Ogilvy

Hi,

I have a list of codes in a column. These codes are in the form of a

number of any length followed by a '/' followed by another number of any
length.