LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default move part of cell to new column

I would like to know if there is some code that can help me with the
following.

I have a column of cells with information similar to this:
$50.00 Gift from Johnson, John
$35.00 Gift from Public, Jimmy
$75.00 Gift from Jones, Billy
etc.
The second part (Gift...) is not necessarily lined up vertically.

I would like to move the "Gift from Johnson, John" part to a new column.

Thanks for your help,
Scott


 
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
Move part of cell only - help please Jude Excel Discussion (Misc queries) 5 March 25th 08 01:01 AM
macro to move part of cell contents to another cell icetoad hisself Excel Discussion (Misc queries) 4 November 27th 06 07:19 PM
Compare part of a cell to a column JessicaZ Excel Discussion (Misc queries) 1 September 18th 06 07:45 PM
How do I copy part of each cell in a column? I should know this! Excel Discussion (Misc queries) 2 May 10th 05 02:04 PM
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) Thomas G. Marshall Excel Discussion (Misc queries) 4 December 18th 04 04:15 PM


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