LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default I need to copy half of the info in a cell...

I am trying to make a song book after importing data into Excel. The title
of the song and the artist are in the same cell, seperated by a double space.
Is there a formula that can copy the info after the double space? I can
replace the double space with a special character if there is a formula that
can read for it.
 
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
Copy info into empty cells below info, until finds cell with new d Fat Jack Utah Excel Discussion (Misc queries) 3 November 16th 08 08:34 PM
How do I copy info in one cell to another worksheet? Tsiri New Users to Excel 1 November 12th 08 12:32 AM
Copy Cell Info Automaticly Ram02Escort Excel Discussion (Misc queries) 0 April 8th 08 12:15 PM
Copy Info from cell to another sheet Jeremy Excel Discussion (Misc queries) 2 January 19th 07 12:41 AM
Copy and insert cell info macro help JackR Excel Discussion (Misc queries) 2 March 21st 06 03:22 PM


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