Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bsantona
 
Posts: n/a
Default store some of the information from one cell into another

I would like to store some of the information from one cell into another. For
instance, information in one cell has StampPDF V 2.3. I would like to cut 2.3
into a different cell. I was wondering if anyone new of the quickest way to
do this. I have about 2000+ cells to work with.
  #2   Report Post  
Smuggy
 
Posts: n/a
Default

If the information you want from the cell is always at the end, and is always
the last 3 characters you could use

=RIGHT(A1,3) assuming that the original information is in cell reference A1

If you actually want to remove the 2.3 from the original cell then

"bsantona" wrote:

I would like to store some of the information from one cell into another. For
instance, information in one cell has StampPDF V 2.3. I would like to cut 2.3
into a different cell. I was wondering if anyone new of the quickest way to
do this. I have about 2000+ cells to work with.

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
List ? - How do I make information in one cell determine list to u Brad_A Excel Worksheet Functions 1 January 18th 05 04:10 PM
Can you conditional format based on information in cell comments? Jflyer Excel Worksheet Functions 1 January 15th 05 01:52 AM
how can i automatically copy the information in one cell on a she. Dan Excel Worksheet Functions 1 November 26th 04 07:03 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
store file saved date in cell Martin Connelly Excel Worksheet Functions 1 November 16th 04 01:32 PM


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