Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default Converting Address from one column to 8 columns

Hi all,
Once again struck with an issue.
Is there any way to split one cell (text) to data to multi columns
(offcourse i know the command "text to columns", based on separator, after
trying that i am writing this. As it was giving single column where there is
no separator or different separator is given.
Any Ideas would be greatly appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Converting Address from one column to 8 columns

I'm not sure I understand what you have in your cells since any character
can be a separator. Can you show us some examples (vary them as much as
possible) of what is in the cells and how you want them to be split apart?

--
Rick (MVP - Excel)


"Vijay DSK" wrote in message
...
Hi all,
Once again struck with an issue.
Is there any way to split one cell (text) to data to multi columns
(offcourse i know the command "text to columns", based on separator, after
trying that i am writing this. As it was giving single column where there
is
no separator or different separator is given.
Any Ideas would be greatly appreciated.


Reply
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
converting hyperlink to actual web address Roger on Excel Excel Discussion (Misc queries) 9 October 29th 08 01:25 AM
Critical - Converting Single Column Address Data into Multiple Col A.J. Excel Worksheet Functions 2 July 10th 08 07:39 PM
name,address in same column different rows. How move to columns kimbafred Charts and Charting in Excel 8 July 20th 07 03:12 AM
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D [email protected] Excel Worksheet Functions 2 October 25th 06 07:45 AM
Separate address column to Five columns harpscardiff Excel Worksheet Functions 1 September 16th 05 11:14 PM


All times are GMT +1. The time now is 02:24 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"