can i change the part of the data in a colum?

P

phil

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 :)
 
K

Kevin Lehrbass

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!
 
P

phil

Thanks Very much Kevin :)

Kevin Lehrbass said:
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!
Click to expand...
 
Top