Can i use text from one cell and insert it in the middle of a sentence on another cell? Mi

**rossw14** · 02-25-2015, 03:18 PM

Hi
the problem i have is i want to add a word in one cell and copy the word to then put into another cell, the problem is that it has to be in with a sentence. It would probably be more easier if i show with the photo I ve attached.

Basically the text from cell 1b needs to be able to fit into cell 1e in a sentence, maybe using a formula? I m not too sure. then i need to be able to duplicate it across a few hundred other rows.

i hope this is understandable, if anybody needs any clarification please ask!

thanks
Regards
Ross Wilkes
1.jpg

**MarvinP** · 02-25-2015, 03:24 PM

Hi Rossw and welcome to the forum,

Here is one way. See the attached. If you want to insert it into the Same Cell in the B column it might take some VBA so you don't get Circular Ref error messages.

**Tony Valko** · 02-25-2015, 03:30 PM

Using a formula...

="Test 123 "&B1&" Test 123"

**rfigueroa1976** · 02-25-2015, 03:31 PM

If the sentence is always going to be the same, this is how. If the sentence changes every row, I don't know how...

Couple of ways i know of:

="This is the first half of the sentence "&B1&" this is the second half of the sentence."
=CONCATENATE("This is the first half of the sentence ", A11, " this is the second half of the sentence.")

Obviously, change the text in the quotes to what you want the sentence to be.

**rossw14** · 02-25-2015, 03:51 PM

hi guys,
thanks for your help with this, i have tried the formula =CONCANTEATE
but this has come up when i tried to click save, as its quite a long text document. is it possible to fix?2.jpg

**Tony Valko** · 02-26-2015, 12:04 AM

As an example, I'm able to use a formula that generates a string over 400 characters long...

=REPT("x",200)&" "&B1&" "&REPT("x",200)

**MarvinP** · 02-26-2015, 12:09 AM

Hi,
In reading the Microsoft page for Concatenate(), it does claim 255 is the max string length. Read it at:
https://support.office.com/en-us/art...rs=en-US&ad=US

So, simply don't use Concantenate and instead use the "&" and Left() and Mid() functions as suggested above.

Can i use text from one cell and insert it in the middle of a sentence on another cell? Mi

LinkBack

Thread Tools

Rate This Thread

Display

Can i use text from one cell and insert it in the middle of a sentence on another cell? Mi

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Re: Can i use text from one cell and insert it in the middle of a sentence on another cell

Thread Information

Users Browsing this Thread

Similar Threads

Insert value from cell in middle of a sentence

[SOLVED] Copying a word from one cell in a different worksheet into the middle of a sentence.

How do you insert a cell's content in the middle of the sentence?

[SOLVED] Possible to insert cell data in the middle of line of text?

Possible to insert cell data in the middle of line of text?

Bookmarks

Bookmarks

Posting Permissions