Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Split a Value

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Killing the split window RWN Setting up and Configuration of Excel 2 October 9th 05 06:21 AM
Enable a new dimention: sub-level of split cells yarp Excel Discussion (Misc queries) 3 August 8th 05 04:11 PM
How do I split the y-axis scale on a chart? Chaz Charts and Charting in Excel 2 April 27th 05 10:13 PM
How do I split a single cell in Excel ? tan Excel Discussion (Misc queries) 2 March 15th 05 01:09 PM
split a single column into 2 separate columns Eve Excel Worksheet Functions 2 March 14th 05 07:33 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"