Text and transpose function (google sheets)

Hi guys,

Can anyone help/advise if this is possible:

="In week 1 you weighed in at: " & TRANSPOSE(B4:B23) "lbs"

I want the text lbs added after my transpose function. Is this possible?

Thanks!

Have you tried this:

="In week 1 you weighed in at: " & TRANSPOSE(B4:B23) & "lbs"

Originally Posted by AliGW

Have you tried this:

="In week 1 you weighed in at: " & TRANSPOSE(B4:B23) & "lbs"

I literally did this just before I read your post and it worked. Thank you so much though Ali!!

No worries!

Just an observation (don't take any offence): do you ever really just sit and try to work things out and/or Google them before asking for help? I honestly think that if you did so, you would not need to ask half as many questions and you would have a much better understanding of what you are doing.