Copy part of a cell

S

Suddes

My problem, I have a cell which displays a value of 4/abcd1
I want another cell to equal this only without the 4/
ie
cell
A1 = 4/abcd1
I want cell B1 to = cell A1 but only ignore the first two charters ie cell B1 will return abcd1

How do I do it? cheers
 
F

Freemini

One way is in B1 type

=MID(A1,3,6)

this will take the text from the 3rd character and the next 6.
If your original data is likely to be longer amend the 6 to whateve
you want.

Another way in B1 type

=MID(A1,FIND("/",A1)+1,6)
this allows for different lengths of data before the / i.e. A/abcd1 bu
will also handle AAA/abcd1

hth

Mik
 
L

LoucaGreen

If you generally want it to ignore the first two characters then try

=MID(A1,3,LEN(A1)-2)

If you want the last four characters, then it is easier with

=right(A1,4)


LoucaGree
 
Top