Help splitting this into another column

[jpatel3868]

How to split stock ticker, bid and ask into three different columns? Need regex help or any other way

[dougperez]

Can you provide the desired output? I cannot understand what do you need.

[jpatel3868]

a

[jpatel3868]

something like this 

[Luke_C · Accepted solution]

Hi @jpatel3868 

See below regex to do this.

(\u+)\s([0-9.]+)\sx\s([0-9.]+)