ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Replicating Text Using "=". (https://www.excelbanter.com/excel-worksheet-functions/89441-replicating-text-using-%3D.html)

MikeinSC

Replicating Text Using "=".
 
In order to save word processing time, I like to use the "=" sign to
replicate text in a cell from one worksheet from a cell in another worksheet
.. Sometimes this function replicates text properly in the cell; sometimes it
justs replicates the formula in the cell. How do I get it to consistently
replicate text from another cell?

Brian Matlack

Replicating Text Using "=".
 

Mike:
I've had similar problems and it typicaly turns out to be the formating
of the cell I'm putting the formula in. Check the formatting to make
sure its set on General before entering the formula


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=543421



All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com