Copying first three characters of text in a cell

K

Kris

I need to concatenate text from two cells but only the first three characters
from one of the cells. Other than subtracting the last 5 characters, is there
a simpler way?

A1 is "ABC1"
B1 is "XYZ RSTU"
I need to display in cell C1 this ABC1-XYZ
I've used this formula =A1&"-"&LEFT(B1, LEN(B1)-5)

Thanks
 
H

HARSHAWARDHAN. S .SHASTRI

Hi Kris,

Use following formula,

=A1&"-"&MID(B1,1,3)

H S Shastri



===================================================
 
D

David Biddulph

Why not just =A1&"-"&LEFT(B1, 3) ?

Hint:
LEFT is a standard Excel function, so if you don't know what it's doing,
look it up in Excel help. The same applies to LEN.
If you haven't used Excel help yet, I would heartily recommend it.
 

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

Cell Range Split into Multiple Cells 6
Referencing the values of multiple cells in conditinal formatting. 0
Show value from one cell in another cell if today falls between a date range 5
Show a cell's formula in text format in a linked cell 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Compare One Cell to the First 10 Characters of Another Cell 9
Split Cell Range into Multiple Cells 2
Concatenate 3

Top