Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

text & formula in same Excel cell 1

Status
Not open for further replies.
gasca

gasca

Programmer
Apr 2, 2003
22
0
0
ES
Is it possible to put an excel text and a formula on the "same" cell?

Thanks.
 
Sort by date Sort by votes
="My Text "&A10

if you need to control the format of the number

="My Text "&TEXT(H11,"0.0")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
101
TomSalvato
TomSalvato
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
111
ladyck3
ladyck3
Bijugate
  • Question
Excel update question
Replies
0
Views
97
Bijugate
Bijugate
ladyck3
  • Locked
  • Question
Excel 365 – (Formula/Function for Hyperlinks) and (Totals Yearly & Quartly) 2
2
Replies
24
Views
226
ladyck3
ladyck3

Part and Inventory Search

Sponsor

Back
Top