trim text string formula

[luvbite38]

Hey,

This should be really ez for most of you...

I have a text xyz-XYZ. where xyz can be any text. How can get the text string on the left before - and also how can get the text string on the right after -.

End results should look like this
Cell A1
xyz
Cell B1
XYZ

Kind Regards,

 

[PaddyD]

find("-",a1)

will return position of the - within the string. use this with left() and mid() functions to get the substrings

 

[Jon von der Heyden]

Left component: =LEFT(A1,FIND("-",A1)-1)

Right component: =MID(A1,FIND("-",A1)+1,255)

 

[luvbite38]

Dude ain't you a LEGEND>>>>>>> Thanks for such FAST AND FURIOUS response.

thanks a Million