ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic Text to column (https://www.excelbanter.com/excel-discussion-misc-queries/30101-automatic-text-column.html)

dinesh

Automatic Text to column
 

::Is there any trick by which the text is automatically separated to the
adjacent cells.

i.e. the text seperated by \" , \" is automatically spreaded to
the adjacent cells as soon as entered. without using the text to
column fuction.


Please mail me at *::


--
dinesh


------------------------------------------------------------------------
dinesh's Profile: http://www.excelforum.com/member.php...o&userid=24177
View this thread: http://www.excelforum.com/showthread...hreadid=377987


Jim Rech

You might be referring to this issue:

http://support.microsoft.com/default...b;en-us;127132

--
Jim
"dinesh" wrote in
message ...
|
| ::Is there any trick by which the text is automatically separated to the
| adjacent cells.
|
| i.e. the text seperated by \" , \" is automatically spreaded to
| the adjacent cells as soon as entered. without using the text to
| column fuction.
|
|
| Please mail me at *::
|
|
| --
| dinesh
|
|
| ------------------------------------------------------------------------
| dinesh's Profile:
http://www.excelforum.com/member.php...o&userid=24177
| View this thread: http://www.excelforum.com/showthread...hreadid=377987
|




All times are GMT +1. The time now is 12:58 AM.

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