CODE EXAMPLE FOR PYTHON

pandas split cell into multiple columns

df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)