store some of the information from one cell into another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Cell Reference, without if statement 4
Get row values into column 3
Referrences of multiple cells from one worksheet to another 3
Pulling data from one cell to another 3
Assigning cell values to variables 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Include a value from one cell within text of another cell. 2
numbering cells 3

Back
Top