Solved

Excel and google docs text format

Posted on 2012-04-07
5
288 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
Comment Utility
Try this:

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

Flyster
0
 
LVL 9

Accepted Solution

by:
statler01 earned 500 total points
Comment Utility
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
Comment Utility
Thanks statler01. I typed it a little too fast!
0
 
LVL 9

Expert Comment

by:statler01
Comment Utility
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
Comment Utility
No problem. That's what I get for rushing!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

743 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

10 Experts available now in Live!

Get 1:1 Help Now