SOLVED

Text and formula in the same cell

Copper Contributor

I'm trying to add text in the same cell that I have a formula in ( Text: 12 month 9102. Formula: =SUM(B3:B200) thanks in advance for any help offered

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
="12 month " &SUM(B3:B200)

@ManasarovarThanks for help

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution
="12 month " &SUM(B3:B200)

View solution in original post