Forum Discussion
Solved
Split string at particular word. (space+word+space)
Hello all: I have a column in Excel that contains person's title and company name separated by " at ". I tried to split with text to column with left most and right most occurrence but could not ...
Guarav, in your texts there is symbol CHAR(160) instead of space. You may use
=IFERROR(LEFT(A31,SEARCH(CHAR(160)&"at"&CHAR(160),A31)),A31)
for the left part, for the right one the formula is the same, attached.
Alternatively you may SUBSTITUTE that symbol on spaces.
Thanks Sergei for replying. Somehow when I am using your formula for other records, it's not working. I've attached the file for your reference.
Best,
G
Guarav, in your texts there is symbol CHAR(160) instead of space. You may use
=IFERROR(LEFT(A31,SEARCH(CHAR(160)&"at"&CHAR(160),A31)),A31)
for the left part, for the right one the formula is the same, attached.
Alternatively you may SUBSTITUTE that symbol on spaces.
- Thanks, Sergei!
You are welcome