Excel Help
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 |
Originally Posted by boxst
(Post 6582455)
For completeness, the answer is:
=LEFT(column,FIND("/",column)-1) Steve I think? he wants to concatonate the two subsets prior to the / in both columns - or am i talking bollox ? :norty: |
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 |
All times are GMT +1. The time now is 07:33 AM. |
© 2024 MH Sub I, LLC dba Internet Brands