PDA

View Full Version : Solved: Text and Value in 1 cell is it difficult?



projectaero
03-27-2010, 04:49 PM
Hello,
I am wanting to know how you would do thi

A1 is what your on
A2 is what you need to be on by the end of the day

[A1] 50
[A2] 100
[A3] Your name


[B1] Hi [A3] you have completed [A1] of [A2] stats..

Bob Phillips
03-27-2010, 04:56 PM
Try

="Hi "&A3&" you have completed "&A1&" of "&A2&" stats..."

projectaero
03-27-2010, 05:50 PM
Thanks heaps

lucas
03-27-2010, 06:03 PM
projectaero, please mark your thread solved using the thread tools at the top of the page.

projectaero
03-27-2010, 06:17 PM
done