• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MID FIND to separate text with /

Hi, HNY all,

I would like help to separate text that contains a "/" and put into a new column.

In column C I've used =TRIM(PROPER(IFERROR(RIGHT($A2,LEN($A2)-SEARCH("/",$A2,1)),""))) which seems to be working perfectly.

However, in Column B I would like to get everything to the left of the "/" or text without so every line in column B is populated

kind regards,

Kelli
 

Attachments

  • Chandoo Mid Find.xlsx
    10.9 KB · Views: 6
Last edited:
Sorry... My mistake.

Use this:
[B2] : =IFERROR(TRIM(PROPER(LEFT(A2,FIND("/",A2)-1))),A2)

Blessings!
"perfect" Love your work!

What are your thoughts on the formula I used above?
It is working, but is there a sequence that should be used when constructing a formula?
 
Kelli, one more option for you
1) Select the data range (like A2 to A11 in your example)
2) Goto Data--> Text to Columns
3) Select Delimited--> then press next
4) Choose delimiters from the given list (if you want to add any other symbol then choose OTHER and mention the symbol in the box)
5) Press Next
6) Choose your Column Data format (By default GENERAL) and write the destination (in your case, write $B$2 or you can write any column you want)
7) Press FINISH

Enjoy!!
 
Back
Top