So I am trying to see about creating a formula to put together text from previous 3 cells.
Example
A1= First Name
B1= Middle Name
C1= Last Name
D1 would display First Middle Last Name
I appreciate any help.
Thanks,
Nick
So I am trying to see about creating a formula to put together text from previous 3 cells.
Example
A1= First Name
B1= Middle Name
C1= Last Name
D1 would display First Middle Last Name
I appreciate any help.
Thanks,
Nick
Last edited by avidcat; 11-12-2012 at 04:03 PM.
Try this:
In cell D1 write: =A1&" "&B1&" "&C1
Try
=A1&" "&B1&" "&C1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Perfect thanks!
Welcome. Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks