Copy cell to a new cell

[mohd21uk]

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.

 

[Ardus Petus]

Hi,

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

Regards,

 

[Bondi]

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