Copy cell to a new cell

  • Thread starter Thread starter mohd21uk
  • Start date Start date
M

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.
 
Hi,

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

Regards,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto copy cell format 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Macro to automatically go to the right of the last colored cell 0
Cell display 2
copy cells become blank 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top