Thread: Function within a cell that has a number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
  
Posts: 120
Default Function within a cell that has a number
try this:
=500&A1+A2

If you want space between two then use this

=500&" "&A1+A2

You can add as many equations or text as u like, just add &

Let me know it it worked

Reply With QuoteReply With Quote