I'm trying to pull certain text out of a cell that's imported in. I'm having a hard time since it's very odd
A1:
8:30 PM EDTKC@ NE
I need to pull out just "KC" It's always going to be right after EDT and either 2 or 3 characters.
A2:
10:20 PM EDTLAC@ Denver
I need "LAC"
Formula:![]()
MID(A1,FIND(" ",A1)+1,256)
This gives me everything that's after the first space. I'm not sure a better approach. Thank you!
Bookmarks