ExcelBanter - Changing none text entry to text?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing none text entry to text? (https://www.excelbanter.com/excel-discussion-misc-queries/149016-changing-none-text-entry-text.html)

Ross

Changing none text entry to text?

Hello all

I hope you can help me. I have imported a worksheet from another source
within this worksheet certain cells contain --:-- I want to create a formula
to change this cell contents to NCO whats the best way of achieving this???
--
Many Thanks
Ross

Toppers

Changing none text entry to text?

Look at Edit=Replace

Find What : --:--

Replace with: NCO

HTH

"Ross" wrote:

Hello all

I hope you can help me. I have imported a worksheet from another source
within this worksheet certain cells contain --:-- I want to create a formula
to change this cell contents to NCO whats the best way of achieving this???
--
Many Thanks
Ross

All times are GMT +1. The time now is 08:27 AM.