Insert value from cell in middle of a sentence

**jw191** · 10-19-2006, 08:54 AM

Hi Guys,

I am trying to get a cell value in the middle of a sentence in another cell. For example cell A1 has the value 50 and represents the numbers of users in a group, and I want to have in cell A2 the following:

There are 50 users in this group

where the value 50 is retrieved from cell A1 and therefore updates automatically when changed.

This sounds like a simple problem but I cant work it out, I have tried searching the command list without success. I know there is the function CONCATENATE and I could hack around to get this to work but its far from Ideal.

Any help would be appreciated. Cheers

**Bryan Hessey** · 10-19-2006, 09:11 AM

="There are "&A1&" users in the group"

**jw191** · 10-19-2006, 09:27 AM

Thanks, exactly what I was after. Impressively illogical, even for office, but works none the less.

**rikaz77** · 12-21-2019, 02:58 AM

Using this on Office365 in 2019. 13 years later works just as good. Makes you respect the value of good information.

**FDibbins** · 12-22-2019, 12:53 AM

Thanks for the feedback, always good to know

Insert value from cell in middle of a sentence

LinkBack

Thread Tools

Rate This Thread

Display

Insert value from cell in middle of a sentence

Re: Insert value from cell in middle of a sentence

Re: Insert value from cell in middle of a sentence

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions