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: 67
Default Cutting text from one cell to paste in another?

Is there a way to cut part of the text in one cell and put it into another?

For example, if I have a dropdown list in cell B3 that includes both an
account number and an account name. I would like cell C3 to take the account
name from cell B3 so all that's left in B3 is the account number.

I know there is an easier way to do this by splitting up the name and number
then using a vlookup for C3 but we need to see both the account name and
number n the dropdown list in order to decide which to use.

Is this possible?

Thnks very much
 
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
word wrap cutting off text Matt Excel Discussion (Misc queries) 6 December 20th 07 12:00 AM
Text Cutting Off When Printing Jenn Maron Excel Discussion (Misc queries) 1 October 10th 07 03:07 PM
Excel Cell Text Cutting Off Jones Excel Discussion (Misc queries) 5 August 6th 07 06:12 AM
Contents of cell not wrapping cutting off text deedeecarr Setting up and Configuration of Excel 2 August 22nd 06 08:42 PM
cutting text Aaron Excel Discussion (Misc queries) 1 December 15th 05 04:13 PM


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