software

Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to have
B1 = 26, and B2 = 25?

Highlight the column, then Data gt; TextToColumns using the decimal point (or
period) as the delimiter........

Vaya con Dios,
Chuck, CABGx3

quot;Gabequot; wrote:

gt; Hello,
gt;
gt; I was wondering if there is anyway to split a value from one cell to two
gt; cells?
gt;
gt; Currently A1 = 26.25 (integer), Is there a way to split this value to have
gt; B1 = 26, and B2 = 25?


Hi, first make sure there is a blank column to the left of your data,
then select your data, go to Data/Text to Columns and use a period as
your delimiter!

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494924Pure genius, Thanks Chuck!

quot;CLRquot; wrote:

gt; Highlight the column, then Data gt; TextToColumns using the decimal point (or
gt; period) as the delimiter........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Gabequot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I was wondering if there is anyway to split a value from one cell to two
gt; gt; cells?
gt; gt;
gt; gt; Currently A1 = 26.25 (integer), Is there a way to split this value to have
gt; gt; B1 = 26, and B2 = 25?

B1 =INT(A1)
B2 =(A1-B1)*100
If negative values possible use TRUNC

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Gabequot; gt; wrote in message
...
gt; Hello,
gt;
gt; I was wondering if there is anyway to split a value from one cell to two
gt; cells?
gt;
gt; Currently A1 = 26.25 (integer), Is there a way to split this value to
gt; have
gt; B1 = 26, and B2 = 25?