Text with a cell reference?

[Rweasel6]

Just need help seeing if there is a way to have text and a separate cell refernce in the same cell. For example

Hi my name is (A1)!

Where anything posted in A1 shows up after the previous text.
Is it possible without VB programming?
Any help would be great!

[theDude]

Try this formula in your cell:

= "Hi my name is " & A1 & "!"

Hope this helps,
theDude

[Rweasel6]

Thanks for the info,
I just couldnt seem to remember how to add the text in with a cell reference and that is exactly it!

[Rweasel6]

Is it possible to then have another formula such as RIGHT or MID a long with the cell reference ?
Say I had a first and last name in cell A1 and only wanted the reference to bring in the first name.
Is this possible as well and if so can it be done with multiple cell references in a longer sentence or paragraph?

[theDude]

Assuming the name in cell A1 is represented as Firstname Lastname (i.e. John Smith), this will work for you:

= "Hi my name is " & MID(A1,1,FIND(" ",A1,1)-1) & "!"

It looks for the space between Firstname and Lastname beginning with the first character position (from left to right) and returns all characters before the position of the space; it will show the Firstname only like

Hi my name is John!

Hope this helps,
theDude