View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Excel 2007 getting error_Using text to column

You cannot use datatext to columns on more than one column


--


Regards,


Peo Sjoblom



"Mac" wrote in message
...
Hi,

I am getting following error message when select 2 columns and click on
Text
to Column in Data option:

'Microsoft office excel can convert only one column at a time. The range
can
be many rows tall but no more than one column wide. Try again by selecting
cells in one column only.'

Please help...
Siraj