Excel: Extracting from a column

IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything after char # 3, but up to the last Numerical DIgit. Column 3, LADD DISTRIBUTION LLC - Everything after the Numerical value.

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of August 11, 2017.

For more resources for Microsoft Excel