Formula for Text instead of numbers

[Closed]
Report
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
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

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,898
read this Microsoft web page:

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

Good Luck