Link to home
Start Free TrialLog in
Avatar of dwcronin
dwcroninFlag for United States of America

asked on

Excel and google docs text format

I have my age in A1.  I want B1 to say, with the proper substitution:
"I am A1 years old."

How do I get the value of A1 in the B1 string?
Avatar of Flyster
Flyster
Flag of United States of America image

Try this:

="I am " & A1 & "years old"

Flyster
ASKER CERTIFIED SOLUTION
Avatar of statler01
statler01
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks statler01. I typed it a little too fast!
Points for this question should have gone to Flyster...
Sorry Flyster - I didn't mean to hijack your solution.
No problem. That's what I get for rushing!