I need to get a text from another text, the same way as I can get a string from another string by its location. What is the function to use?
line1=“Miami@LosAngeles”
put range("@", line1) into locationofatsign
put length(line1) into lengthofline1
I need to get “Miami” from “Miami@LosAngeles” so basically i need to get the first 5 letters before the @ sign. I’d like to get the letters after the @ sign too which will be “LosAngeles”
How do I get the text based on the location of another text?