LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
text box in Excel 2007 Simon Minder Excel Worksheet Functions 1 March 12th 08 04:12 PM
IF Function for column containing text - Excel 2007 New User Judy New Users to Excel 6 July 26th 07 10:10 PM
Excel 2007 Text Box Nick Excel Discussion (Misc queries) 3 May 10th 07 07:12 PM
Excel 2007 Filter in Column Steve300 Excel Worksheet Functions 1 February 15th 07 05:17 PM
Column Header Excel 2007 Mark B Excel Discussion (Misc queries) 3 February 2nd 07 01:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"