Macro Help Copy Specific Text from One cell into another [Solved/Closed]

Posts
1
Registration date
Tuesday June 4, 2013
Last seen
June 4, 2013
- Jun 4, 2013 at 05:01 PM - Latest reply:
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Jun 16, 2013 at 10:20 AM
Here is the scenario:

I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or moved to the cell right beside it. i.e.

A B
Thisisit-0000000000 => 0000000000

And I need this done for the entire table so thus in a loop. Is there any way to specify the copying of only the last ten characters of a cell into the cell beside it?

Thanks in advance for anyone who looks at this!
See more 

5 replies

Best answer
Posts
10861
Registration date
Monday June 3, 2013
Status
Contributor
Last seen
November 17, 2018
- Jun 4, 2013 at 05:11 PM
1
Thank you
=RIGHT(C11,3)
Where C11 is the cell to check and retrive the last 10 from, in this example, we are only getting the last three(3). ONce you have made the calculation work in one cell, click it, drag it for the whole column, and check to see that the formula is correct in all places. If you do the first 2 cells, Excel will complete the rest with a drag of cells.

If you really want "records", then you should be using a DB and not a spreadsheet.

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1692 users this month

Best answer
1
Thank you
Use formula =right(A1,10)

if you added this formula to b1, this would only take the 10 letters from the right in A1

Thank you, dcxo 1

Something to say? Add comment

CCM has helped 1692 users this month

Posts
10861
Registration date
Monday June 3, 2013
Status
Contributor
Last seen
November 17, 2018
- Jun 6, 2013 at 09:26 AM
I agree!
sorry, I thought I was breaking new ground!
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Jun 16, 2013 at 10:20 AM
why break any thing. and if you have to break any thing, why break new stuff. break old :)