I need a formula

R

RBD

I need a formula that would allow me to copy one cell to another as
well as remove the first three characters.

example

cel a - 12321232 would copy to cell be as - 21232

If anyone could help me that would be soo awesome
 
M

MartinW

Hi,

Try one these
=RIGHT(A1,5)

If the lenght of your data is fluctuating then
=RIGHT(A1,LEN(A1)-3)

If you need them to return a number instead of text
then tack *1 on the end of them.

HTH
Martin
 

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

Need a formula to act as a value 1
need formula to set charakters 1
help with formula 3
Excel Need Countifs Formula Help 0
Conditional formatting based on formula cell 6
Excel VBA 1
Clever formula required (to find the word directly preceding mychosen word) 3
Autocopy the first cell with more than 30 characters to a different sheet? 1

Top