VBA Excel work with strings

Question

I have following string values in cells like

"EnglishText / OtherLanguageText"
or
"UniversalText"

I need to get 2 substrings from that like "EnglishText" and "OtherLanguageText" or "UniversalText" (text which not contain "/")

Im selecting data with command

wbImportFrom.Sheets("Sheet 4").Cells(4, 6 + x).Value

How can i do that ? :-) Thank you

in VBA use Split() and on the spreadsheet =FIND() and =MID() — user2140173
– user2140173, Commented Aug 29, 2014 at 10:43

Tyler · Accepted Answer · 2014-08-29 10:48:59Z

3

Check out the Split function, and use the "/" as the delimiter.

Something like

My_String = Sheets("Sheet 4").cells(4, 6 + x).value
String_array = Split(My_String,"/")

should do the trick. Bear in mind that you will then be working with an array.

answered Aug 29, 2014 at 10:48

Tyler

584 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1