Solved

Excel and google docs text format

Posted on 2012-04-07
5
289 Views
Last Modified: 2012-04-07
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?
0
Comment
Question by:dwcronin
  • 3
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 37820185
Try this:

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

Flyster
0
 
LVL 9

Accepted Solution

by:
statler01 earned 500 total points
ID: 37820189
Flyster is correct; Just a technicality... There should be another space between A1 and "years old".

Corrected would be:
="I am " & A1 & " years old"

Note the space at the front of " years old"
0
 
LVL 22

Expert Comment

by:Flyster
ID: 37820203
Thanks statler01. I typed it a little too fast!
0
 
LVL 9

Expert Comment

by:statler01
ID: 37820322
Points for this question should have gone to Flyster...
Sorry Flyster - I didn't mean to hijack your solution.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 37820376
No problem. That's what I get for rushing!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now