Hi

I have a cell value in the format 90TN82C128004K00. I would like to copy the
first two digits to another cell i.e. 90 and follow it up with a dummy code
00CPSS00 which will be standard for all values. the new cell should have the
following value 9000CPSS00. Is there an automated function that can do this
for me.

Hi,

If you data is in A1 enter in B1:
=LEFT(A1,2)&"00CPSS00"

Regards,
--
AP

"mohd21uk" <u20517@uwe a écrit dans le message de news:5e5292da6a2d1@uwe...
Hi

I have a cell value in the format 90TN82C128004K00. I would like to copy
the
first two digits to another cell i.e. 90 and follow it up with a dummy
code
00CPSS00 which will be standard for all values. the new cell should have
the
following value 9000CPSS00. Is there an automated function that can do
this
for me.

Hi,

Try this formula in the cell where you want the result - change the
90TN82C128004K00 to a cell reference where you have the value you want
to copy from..

=LEFT(90TN82C128004K00,2)&"00CPSS00"

Regrdas,
Bondi