Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
Hi,
Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
=A2 & B2 & "." & C2
-- Gary''s Student - gsnu201001 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
Use: & instead of: +
Micky "Alain Dekker" wrote: Hi, Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
=A2&B2&"."&C2
or without the need for col A $3.47 =DOLLAR(B2&"."&C2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Alain Dekker" wrote in message ... Hi, Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
Hi Alain
Try this =(A9&B9&"."&C9)*1 Bonne chance John "Alain Dekker" wrote in message ... Hi, Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
Although your example involves the $ sign - please take into consideration
that the DOLLAR Function currency symbol depends upon your(!) Language settings in the Control Panel. So - if you live in the UK or in France the result of the DOLLAR function will, eventually, display: £ or: Micky "Alain Dekker" wrote: Hi, Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine strings and numbers
Thanks for all the answers. Yes, that was what I was looking for, the
ampersand &. "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... Although your example involves the $ sign - please take into consideration that the DOLLAR Function currency symbol depends upon your(!) Language settings in the Control Panel. So - if you live in the UK or in France the result of the DOLLAR function will, eventually, display: or: ? Micky "Alain Dekker" wrote: Hi, Using Excel 97. I'm trying to generate a list of costs of some stock items: So I have columns: Dollar_Symbol Dollar_Amount Dollar_Cents eg. Column A Column B Column C Dollar_Symbol Dollar_Amount Dollar_Cents $ 3 47 $ 12 09 etc Now I want to concatenate these into a string ie. something like this: A2+B2+"."+C2 (which should $3.47) A3+B3+"."+C3 (which should $12.09) but I can't get the formulas to work. I'm sure this is simple, I'll kick myself later, I promise! Thanks in advance, Alain . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting strings of consecutive numbers in a column | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
Strings and numbers in cells | Excel Discussion (Misc queries) | |||
2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
Extract numbers from strings | Excel Worksheet Functions |