Splitting text into two columns

[needsexcelhelp]

I'm trying to split text in one column into two separate columns with a
couple of exceptions. I need to paste a formula down a column to produce the
following results in Column B & C

Example:

A B C
1 AAA1*111-1 AAA1 111-1
2 AAA2*111-2 AAA2 111-2
3 AAA AAA
4 Z Z

 

[teylyn]

Hi,

you can use text to columns with the space as the delimiter to do that
Data - Text to columns - Delimited - tick space - OK

hth




I'm trying to split text in one column into two separate columns wit
a

 

[David Biddulph]

You don't need formulae. Use Data/ Text to columns, and specify the
asterisk as the delimiter.