Extracting text from string

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

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 said:
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?
Click to expand...

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 said:
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,
Click to expand...

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
 
Back
Top