How Do You Use Words Instead Of Numbers In An Excel Formula?
Thursday, December 31st, 2009 at
5:16 am
I would like to add the text from one cell into another cell and then have an additional phrase at the end. So for example:
B4
[Nike Athletic Shoe #TR2365]
E4
[=B4 is available for free shipping....]
The phrase after about free shipping would be the same throughout column E but I want the first part about the style # to match the product in column B and change accordingly.
Tagged with: Excel • Formula • Instead. • Numbers • Words
Filed under: Free Baby Stuff
Like this post? Subscribe to my RSS feed and get loads more!
Simple
the ‘&’ Sign is use to concatanate or join two Sentances together.
=b4 & ” is abailale for free shipping…”
above function will join the B4 cell value followed y the string after & sign enclosed within quotes
enclosure is very important to use with sentances or words if you dont use quote sign excel will try to find dome keywords or varible or range name defined in excel. if excel will not find it then it will return an error.
another way to use CONCATANATE FUNCTION
=CONCATENATE(B4,” is available for free shipping”)
But still you will have to Enclose the Sentances in Quotes.
(*.*)
You can put the phrase ” is available for free shipping…” (space before the is) in a cell say H1.
Then in E4 would be “=B4&$H$1″. This you can copy down and save some typing