Calc to remove letter after space

[Scott Hoffman]

I have an import field that has Id numbers that look like (TWC-1707 A , TWC-1707 B , BNC-123 , RWA-34567 A)  I'm looking to remove the A,B,C from the Field and put it in another field along with the first part so a field "Id" will have TWC-1707 A , field "MasterId" will be TWC-1707 and field "partnumber" will be A. Is there a calculation to split the field after a space?

this is importing from a 3rd party database that cannot be changed. 

 

[Scott Hoffman]

Found this...works great

https://www.briandunning.com/cf/1659

[Lee Smith]

For the first field try Leftwords ( yourField ;  2)

For the second field try (Rightwords ( yourField ;  1)