Can unmerged cell contents be split to another cell

K

Karyn

I have 17 digit/letter combination (vehicle VIN) that was imported in to
excel. The VIN number was not merged, it came over in one cell. I would
like to separate the last seven characters (our stock #) into a different
cell. Is this possible?
 
D

Duke Carey

=right(vin #,7) will get the last 7 characters
=left(vin#,10) will get the first 10 characters
 

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

Conditionally format cell to turn red after lookup match 5
Editing the contents of a cell 6
Combining Cell Contents - entire columns 7
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Easiest way to extract characters in a cell LEFT or RIGHT of a sym 2
split the contents of a cell 6
How to split the contents of a cell between two cells. 4
Write formula for simple copy and paste to another cell 1

Top