Separating columns.

T

TriciaLeann

Say you have a box. A1. If you type 6 in it then put a space then -5. I need
to have the -5 in B1 and have the 6 stay in A1. Pretty much if you could
split the colums, that's what I need to do. Anyone understand that question
enough to help me?
 
S

Simon Lloyd

in order to show 6 -5 in a cell you would have to format it as text, i
order to show the -5 in the next column you would need to format it a
text but you cant use a formula in a text formatted cell, what is it yo
are trying to do

Here's the formula by the way
=A1-LEN(A1)-FIND(" ",A1,1
There are smarter ways :

TriciaLeann;488657 said:
Say you have a box. A1. If you type 6 in it then put a space then -5.
nee
to have the -5 in B1 and have the 6 stay in A1. Pretty much if yo
coul
split the colums, that's what I need to do. Anyone understand tha
questio
enough to help me
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
Top