| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i change the part of the data in a colum?
i need to know if i can change the last 2 digit's for an entire colum. it
currently has 8-10 digit's but i need to alter the last 2 for all rows. Is this possible and how, if it is? Thanks Phil :) |
|
#2
|
|||
|
|||
|
can i change the part of the data in a colum?
Hi Phil,
If you have your list of numbers (8 to 10 digits) in column A, put this formula =MID(A1,1,LEN(A1)-2) &C1 in column B (copy formula down to last corresponding entry in Column A). In Column C, insert the numbers that you want added. The formula in column B will extract the numbers in column A (except the last 2 numbers) and add the numbers that you have placed in column C. You may want to copy column B and past special values only in another column. If you have any questions let me know and have a great weekend! -- Kevin Lehrbass www.spreadsheetsolutions4u.com "phil" wrote: i need to know if i can change the last 2 digit's for an entire colum. it currently has 8-10 digit's but i need to alter the last 2 for all rows. Is this possible and how, if it is? Thanks Phil :) |
|
#3
|
|||
|
|||
|
can i change the part of the data in a colum?
Thanks Very much Kevin :)
"Kevin Lehrbass" wrote: Hi Phil, If you have your list of numbers (8 to 10 digits) in column A, put this formula =MID(A1,1,LEN(A1)-2) &C1 in column B (copy formula down to last corresponding entry in Column A). In Column C, insert the numbers that you want added. The formula in column B will extract the numbers in column A (except the last 2 numbers) and add the numbers that you have placed in column C. You may want to copy column B and past special values only in another column. If you have any questions let me know and have a great weekend! -- Kevin Lehrbass www.spreadsheetsolutions4u.com "phil" wrote: i need to know if i can change the last 2 digit's for an entire colum. it currently has 8-10 digit's but i need to alter the last 2 for all rows. Is this possible and how, if it is? Thanks Phil :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change lowercase data to capped data? | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| change directory for refresh data | Excel Discussion (Misc queries) | |||
| VBA: Looked up data / now how do I change it? | Excel Worksheet Functions | |||
Linear Mode
