I have a text cell and I want to inport a value into the cell

G

gtf1949

I have a cell with text and want to import a value from elsewhere in the
spreadsheet to make it part of the cell.
--
 
D

David Biddulph

="ABC "&A1&" DEF" will include the value of A1 in the middle of the text
string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Newbie Help - IF Yes No Function 0
Cell data entering slow! 0
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Adding cells until they are greater than a lookup cell and returning a value 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Need Help with a VBA subroutine 0

Top