View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mangesh_yadav[_42_] mangesh_yadav[_42_] is offline
external usenet poster
 
Posts: 1
Default Siple but what was the formula for splitting names?

Well, I may not have a shortcut, but depending on what you need, yo
could use the feature in the menu. Do the following:
Select the column in which you have the data to be split. Click Data
Text to columns. Select delimited and then space and ok.

-manges

--
Message posted from http://www.ExcelForum.com