Hello

I have a column in excel that contains "xxx/yyyyy" and "xx/yyyyy" etc .. (i.e. characters a '/' and then more characters).

I would like a column next to it that takes JUST the characters before the '/', how can I do that?

Thanks for your help!

Steve

 

For completeness, the answer is:

=LEFT(column,FIND("/",column)-1)

Steve

 

That seems to only take the values before the / in the first column.
I think? he wants to concatonate the two subsets prior to the / in both columns - or am i talking bollox ?

 

Nope, it was that the but before the '/' could be variable lengths (in 10,000 columns!) so I couldn't just substring it.

Thanks for the reply.

Steve