right justify text ot columns?

  • Thread starter Thread starter judoist
  • Start date Start date
J

judoist

I have a column with lots of figures ranging between one and fou
digits. I want to place digits into separate columns using text t
columns but right justified. I thought right justifying the figure
first then using text to columns would work but everything stil
appears left justified. Any suggestions
 
Hi

The justification of a cell is just cosmetic. You can use Text to Columns
whatever the formatting is. An alternative is to use formulas:

=MID(A1,1,1)
=MID(A1,2,1)
=MID(A1,3,1) etc
Once done, if you want it right-justified, just format it as such.
 
Thanks, but not quite what i meant.

As an example, lets say all my figures ranging from 1 to four digit
are in column one. Columns 2 to 5 will be where the results will b
displayed once i have used text to columns to separate each number int
an individual digit. So number 3254 in column one would be 3(in colum
2), 2 in column three, 5 in column 4 etc. Number 24 in column one woul
be 2 in column two and 4 in column three.

I'm trying to get Excel to shift everything to the right so number 2
is displayed as 2 in column 4 and 4 in column five. If the number was
it would show as 1 in column five.

Natha
 
Hi

Try these:
Col 2
=IF(LEN(A1)>3,MID(LEN(A1)-3,1,1),"")
Col 3
=IF(LEN(A1)>2,MID(A1,LEN(A1)-2,1),"")
Col 4
=IF(LEN(A1)>1,MID(A1,LEN(A1)-1,1),"")
Col 5
=RIGHT(A1,1)
 
Hi again

Doesn't seem to be working. I use Excel 2000. Do you think that migh
have something to do with it?

Natha
 
No - because I use XL2000 too!! What does it do - or what doesn't it do? It
works OK for me - with your data in A1. What results are you getting?
 
Back
Top