| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting two cell values into a new cell + text
I am likely making this much more difficult than it needs to be... I need to take the numeric values from two cells and insert them into a new cell in this format: "898 - 1398". Where 898 and 1398 are numeric values generated by a formula and are subject to change. What I have is: =VALUE(A1)&" - "&VALUE(A2) but the result gives me one or more decimal places in each number result which I know is a result of the string concatination process. My question is: How can I rewrite this cell's formula to zero out the decimal entries form the source cells which is hidden from view due to its superfluous nature, but makes its way into my string result? Thanks for the help, I know I am the N00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
=TEXT(A1,"0")&" - "&TEXT(A2,"0")
-- Kind regards, Niek Otten "mmednick" wrote in message ... I am likely making this much more difficult than it needs to be... I need to take the numeric values from two cells and insert them into a new cell in this format: "898 - 1398". Where 898 and 1398 are numeric values generated by a formula and are subject to change. What I have is: =VALUE(A1)&" - "&VALUE(A2) but the result gives me one or more decimal places in each number result which I know is a result of the string concatination process. My question is: How can I rewrite this cell's formula to zero out the decimal entries form the source cells which is hidden from view due to its superfluous nature, but makes its way into my string result? Thanks for the help, I know I am the N00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
Hi
=A1 & " - " & A2 Arvi Laanemets "mmednick" wrote in message ... I am likely making this much more difficult than it needs to be... I need to take the numeric values from two cells and insert them into a new cell in this format: "898 - 1398". Where 898 and 1398 are numeric values generated by a formula and are subject to change. What I have is: =VALUE(A1)&" - "&VALUE(A2) but the result gives me one or more decimal places in each number result which I know is a result of the string concatination process. My question is: How can I rewrite this cell's formula to zero out the decimal entries form the source cells which is hidden from view due to its superfluous nature, but makes its way into my string result? Thanks for the help, I know I am the N00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
=ROUND(A1,0)&" - "&ROUND(A2,0)
-- Regards, Dave "mmednick" wrote: I am likely making this much more difficult than it needs to be... I need to take the numeric values from two cells and insert them into a new cell in this format: "898 - 1398". Where 898 and 1398 are numeric values generated by a formula and are subject to change. What I have is: =VALUE(A1)&" - "&VALUE(A2) but the result gives me one or more decimal places in each number result which I know is a result of the string concatination process. My question is: How can I rewrite this cell's formula to zero out the decimal entries form the source cells which is hidden from view due to its superfluous nature, but makes its way into my string result? Thanks for the help, I know I am the N00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
The solutions with the TEXT and ROUND functions and a second variable set to 0 both seem to work, but they cut out the comma I need in numbers grater than one thousand, any thought on how to keep comma format? The N00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
bump the n00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting two cell values into a new cell + text
=TEXT(A1,"#,#")&" - "&TEXT(A2,"#,#")
-- Regards, Dave "mmednick" wrote: bump the n00bish -- mmednick ------------------------------------------------------------------------ mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404 View this thread: http://www.excelforum.com/showthread...hreadid=491155 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Linear Mode
