#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger
 
Posts: n/a
Default Split 2 words

I have 2 words I each cell, I would to put the 2nd word in a new cell, how am
I doing it?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Split 2 words

Space delimited? Datatext to columnsdelimited next, space as delimiter and
finish
make sure that the column to the right is empty before doing this

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Roger" wrote in message
...
I have 2 words I each cell, I would to put the 2nd word in a new cell, how
am
I doing it?



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 cells below header column: HBH Gloria Excel Worksheet Functions 2 March 9th 06 01:01 PM
Split sentences into words sparx Excel Discussion (Misc queries) 5 February 22nd 06 07:51 PM
Split the words Kelvin Lee Excel Discussion (Misc queries) 1 October 10th 05 03:22 PM
How do I split a cell of 2 words into two cells Steven S Excel Worksheet Functions 4 September 13th 05 03:57 PM
triadic combinations of words jayock02 Excel Worksheet Functions 1 June 19th 05 02:10 AM


All times are GMT +1. The time now is 09:34 PM.

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

About Us

"It's about Microsoft Excel"