CONCATENATE Text and Values

  • Thread starter Thread starter umpie
  • Start date Start date
U

umpie

I'm trying to CONCATENATE two cells containing TEXT and one cel
containing a VALUE. Then ADD up the CONCATENATED Values. Any Hel
would be great.

Thank
 
umpie,

You cand "add" text to a value.
If the text is a number formatted as text you can convert it
to a value before trying to do any math with it.
Would help if you posted exactly what text/values you're
working with and what results you're looking to get??

John

umpie said:
I'm trying to CONCATENATE two cells containing TEXT and one cell
containing a VALUE. Then ADD up the CONCATENATED Values. Any Help
would be great.

Thanks


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Hi

You can sum numbers, but not texts!
For case you concatenate numeric values, like
A1=2
B1=3
=A1&B1 returns '23'
then use the next formula, which returns number, instead
=(A1&B1)*1

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


umpie said:
I'm trying to CONCATENATE two cells containing TEXT and one cell
containing a VALUE. Then ADD up the CONCATENATED Values. Any Help
would be great.

Thanks


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top