Macro Help Copy Specific Text from One cell into another
Solved/Closed
steve22522
Posts
1
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013
-
Jun 4, 2013 at 05:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2013 at 10:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2013 at 10:20 AM
Related:
- Macro Help Copy Specific Text from One cell into another
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Run macro when cell value changes - Guide
- Automatically Run Macro from a calculated cell value change ✓ - Excel Forum
- Macro to copy data from one workbook to another based on criteria ✓ - Excel Forum
2 responses
=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.
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.
Use formula =right(A1,10)
if you added this formula to b1, this would only take the 10 letters from the right in A1
if you added this formula to b1, this would only take the 10 letters from the right in A1
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2013 at 10:20 AM
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 :)