ExcelBanter - how to change data in worksheet in text without confirming each s.

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

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

- - how to change data in worksheet in text without confirming each s. (https://www.excelbanter.com/excel-discussion-misc-queries/3974-how-change-data-worksheet-text-without-confirming-each-s.html)

Ronald

how to change data in worksheet in text without confirming each s.

how to change data in worksheet in text without confirming each single cell
with F2

Max

One way to try:

Select the column
Click Data Text to Columns Finish

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ronald" wrote in message
...
how to change data in worksheet in text without confirming each single
cell
with F2

All times are GMT +1. The time now is 05:56 PM.