?
Solved

Excel and google docs text format

Posted on 2012-04-07
5
Medium Priority
?
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

770 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