From 1001 to 1001-1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steve Dee

Col A1 I have 1001 In Col B1 I would like to put a -1 so it looks like
1001-1 please.

Secondly col C1 I have 23 in Col DI wolud like to put in front off it 10 to
look like 1023 please.

Thankyou for yor time.
 
Hi Steve

Put the following formula into cell B1
=A1&"-1"
Put the following formula into cell D1
="10"&C1

Find more about this formula by reasearching "Concatenate"
 
Thanks Kim


Kim said:
Hi Steve

Put the following formula into cell B1
=A1&"-1"
Put the following formula into cell D1
="10"&C1

Find more about this formula by reasearching "Concatenate"
Click to expand...
 
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

vlookup error... 3
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
Hyperlink text from linked workbook 1
Change 4 to Wiri 3
Create search in excel 2
Help to build a table 5
If Hours >0, If Volume <= 0,(and vice-versa) then.... 4
Adding with & 3

Back
Top