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

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

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