Opposite of Concatenate function?

stylin99

New Member
Joined
Feb 27, 2002
Messages
2
I need a function or VBA code to pull the last 6 digits out of a whole column of cells. Anybody know this? It's a list of vehicle VIN numbers and I need to make a separate column of just the last 6 digits of that VIN. Help! Thx.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Function(s) exists for this sort of thing:

=Left(A1,2) would give the first two characters of A1
=Right(A1,2) would give last two
=mid(A1,2,1) would give one character starting at character 2.

Hope this helps
 
Upvote 0
If VIN numbers are fixed length you can use the Data | Text to Columns... menu command. BTW, the "opposite of concatenation" is called parsing.
This message was edited by Mark W. on 2002-02-28 06:45
 
Upvote 0
> BTW, the "opposite of concatenation" is called parsing.

Exploding might be more appropriate here than 'parsing' which has a special, technical meaning in linguistics and computer science and involves more often not the syntax of sentences or expressions in a programming (or command) languages.
 
Upvote 0
On 2002-02-28 07:22, Aladin Akyurek wrote:
> BTW, the "opposite of concatenation" is called parsing.

Exploding might be more appropriate here than 'parsing' which has a special, technical meaning in linguistics and computer science and involves more often not the syntax of sentences or expressions in a programming (or command) languages.

"Parse" is accepted terminology for Excel. In fact as indicated in the Help topic for "Frequently asked questions about upgrading from Microsoft Excel 4.0" there used to be a Data | Parse menu command which was replaced by the Data | Text to columns... menu command. Currently, there's a Help Index entry for "parsing text into columns" that's linked to the Help topic for "Separate copied text data into columns".
 
Upvote 0
Hello friend

I have found that instead of using the concantenating function,The & (and) work just as good especially for VB.

Lot of luck
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top