Formula Question

[Hittin_Provs]

I have a in Col A a list of strings which are either 2 or 3 digit
characters, and I would like to break them apart and put them in the 3
adjacent columns.


AK
34
89s



AK A K
23 2 3
89s 8 9 s



I know that I could use the Left function for the first column, but am
not sure about the other 2 characters if there are 2.

Thanks in advance,

Andrew

 

[RagDyer]

Select your data, then:

<Data> <Text To Columns> <Fixed Width> <Next>

In the "Data Preview" window, click at each character to place a "Break
Line" exactly where you want a new column.
Then <Finish>.

 

[Dave Miller]

I believe this is what you are looking for:

if "89s" is in "A1"

=left(A1,1) 'Returns 8
=mid(A1,2,1) 'Returns 9
=right(A1,1) 'Returns s

David Miller


RagDyer wote:

 

[bigwheel]

Use RIGHT for the last character and MID for th one in the middle (assuming
there's a maximum for three characters)
For example, in col B you would have =LEFT(A1,1)
In col C, =IF(LEN(A1)=3,MID(A1,2,1),RIGHT(A1,1))
In col D, =IF(LEN(A1)=3,RIGHT(A1,1),"")

 

[Hittin_Provs]

Thank you very much.,

Use RIGHT for the last character and MID for th one in the middle (assuming
there's a maximum for three characters)
For example, in col B you would have =LEFT(A1,1)
In col C, =IF(LEN(A1)=3,MID(A1,2,1),RIGHT(A1,1))
In col D, =IF(LEN(A1)=3,RIGHT(A1,1),"")