Text help in excel

Solved/Closed

larry - Aug 13, 2010 at 05:22 PM
larry - Aug 16, 2010 at 08:10 AM

Hello,

i need to get 2 text cells on sheet 1 to list in 1 cell on page 2 any help would be cool with me since i am new to this neet thing called excel where has it been all my life...

sheet 1 cell D17 ABC company name
sheet 1 cell n17 Canoga Park, CA
needs to read on sheet 2 in cell D19: ABC company name Canoga Park, CA

PS i am using 2007
thanks in advance larry

Text help in excel
Excel date format dd.mm.yyyy - Guide
Number to words in excel - Guide
Screenshot in excel - Guide
How to enable vba in excel - Guide
Transfer data from one excel worksheet to another automatically - Guide

2 replies

Answer 1 / 2

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 13, 2010 at 09:56 PM

=Sheet1!D17&" "&Sheet1!N17

larry
Aug 16, 2010 at 08:10 AM

thank you for the plug~n play answer

Answer 2 / 2

larry
Aug 16, 2010 at 08:09 AM

thank you for the plug ~n play answer !!!!!!!
whooooooooo hooooooo.... i think i pulled something lol

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to use conditional format based on text?

Removing " false" value in "IF"

Similar discussions

Subscribe To Our Newsletter!