M
Mike P
Is it possible to insert a cell reference in the middle
of text?
of text?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Mike,
If I understand your question, you want to do something like
="Some text "&A1&" more text"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
If I understand your question, you want to do something like
="Some text "&A1&" more text"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
P
Peo Sjoblom
Yes, depending what it is you have to deal with it differently
="So fair thou art my bonnie lass "&C3
or for a date
="So fair thou art my bonnie lass "&TEXT(C3,"mm/dd/yy")
so put the string in quotations and then concatenate with an ampersand
="So fair thou art my bonnie lass "&TEXT(C3,"mm/did/yy")&" So deep in love
am I"
="So fair thou art my bonnie lass "&C3
or for a date
="So fair thou art my bonnie lass "&TEXT(C3,"mm/dd/yy")
so put the string in quotations and then concatenate with an ampersand
="So fair thou art my bonnie lass "&TEXT(C3,"mm/did/yy")&" So deep in love
am I"
M
Mike P
Thanks! That works. One more question if I may, can
this number be formatted (like to currency)?>-----
Original Message-----
this number be formatted (like to currency)?>-----
Original Message-----
G
Guest
Thanks! That worked. One more question if I may: Can
this number be formatted (as in currency)?
this number be formatted (as in currency)?
C
Chip Pearson
Mike,
Sure, you can use the TEXT function to format the cell value any
way you want. For example,
="some text "&TEXT(A1,"$#,##0.00")&" more text"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Sure, you can use the TEXT function to format the cell value any
way you want. For example,
="some text "&TEXT(A1,"$#,##0.00")&" more text"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
Perfect! Thank you very much!
-----Original Message-----
Mike,
Sure, you can use the TEXT function to format the cell value any
way you want. For example,
="some text "&TEXT(A1,"$#,##0.00")&" more text"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
.