Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Macro to split mult text in the cell to separate cells


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Macro to split mult text in the cell to separate cells

Hi Floss

Use DataText to Columns in the Menu Bar

--
Regards Ron de Bruin
http://www.rondebruin.nl


"floss" wrote in message ...



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default Macro to split mult text in the cell to separate cells

floss

DataText to Columns.

Play with the options and parameters to see if you can come up with some
combination.

Gord Dibben Excel MVP

On Sat, 5 Jun 2004 09:46:02 -0700, "floss"
wrote:


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
split text and numbers into separate cells Julie Excel Discussion (Misc queries) 5 April 2nd 23 07:11 PM
How to split number and text string to separate cells? Lai704 Excel Discussion (Misc queries) 4 September 29th 08 02:18 AM
split text into separate cells jtaiariol Excel Worksheet Functions 7 May 7th 07 09:32 PM
Split date in cell into 2 separate cells Jambruins Excel Discussion (Misc queries) 1 August 9th 06 06:16 PM
Split data from one cell to two separate cells Michele Excel Worksheet Functions 2 October 25th 05 09:27 PM


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

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"