Formula for Text instead of numbers

Closed
KP - Jan 28, 2010 at 09:47 AM
xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Jan 28, 2010 at 02:38 PM
Hello,

I am trying to get text to appear on one Excel worksheet when I enter it into another Excel worksheet. Both worksheets are contained in the same Excel doc.
Example: [Sheet1] Column A:Row 1 - "Susie Sunshine"....then I want "Susie Sunshine" to automatically be entered on [Sheet2] into the cell I assign in.

I am able to do this with numbers but is there a way to make this happen with words???

Any help would be greatly appreciated. Also, feel free to spell it out for me as I am new to Excel and may not understand a lot of codes, etc.

Thanks, KP

1 reply

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,830
Jan 28, 2010 at 02:38 PM
read this Microsoft web page:

http://office.microsoft.com/en-us/excel/HA011366191033.aspx

Good Luck
0