How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

hi
if string is in colurn a...
in column b put...=LEFT(A1,3)
in column c put...=MID(A1,5,3)
in colurrn d put...=MID(A15,9,3)

regards
FSt1

"Confused" wrote:

How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

Confused wrote:
How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

How about Data/"Text to Columns" using the slash as a delimiter?

Beege

The string can vary and will have different combinations, ie BB/AAA/B or
/B/B-.
Is there a formula that will just extract the characters before the "/"? so
in the string BB/AAA/B, column 1 will have BB, column 2 will have AAA, column
3 will have B.

Thanks,

"Confused" wrote:

How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

Confused wrote:
The string can vary and will have different combinations, ie BB/AAA/B or
/B/B-.
Is there a formula that will just extract the characters before the "/"? so
in the string BB/AAA/B, column 1 will have BB, column 2 will have AAA, column
3 will have B.

Thanks,

"Confused" wrote:

How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

1] Select your column
2] Go to menu item Data, then Text to Columns in the list of Data options
3] A dialog box will appear. You can choose either "delimited" or "fixed
width"
4] Choose "delimited", then next.
5] Different kinds of delimiters are displayed. Choose the "other" box
and enter a front slash mark.
6] Click "Okay"

Still confused?

Beege