Splitting text from one cell into 2 columns - automatically

[rickh606]

Hello everyone, I just joined and I may have missed this question being answered somewhere in the forum, so please forgive me if it has been duplicated.

I am scanning in a 19 digit number from a barcode and hat I would lie to do I take that text and ten split it into the next 2 cells on the same row. Basically I am splitting the first 8 characters (Item #) and the next 11 characters (serial #).

Here is a brief sample of what the data should look like:

[TABLE="width: 240"]
<colgroup><col width="146" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5176;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3128;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3072;"> <tbody>[TR]
[TD="width: 146, bgcolor: transparent"][/TD]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 86, bgcolor: transparent, align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 240"]
<colgroup><col width="146" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5176;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3128;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3072;"> <tbody>[TR]
[TD="width: 146, bgcolor: transparent"]7101110850217358001[/TD]
[TD="width: 88, bgcolor: transparent"]71011108[/TD]
[TD="width: 86, bgcolor: transparent, align: right"]50217358001[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]7101110850562302001[/TD]
[TD="bgcolor: transparent"]71011108[/TD]
[TD="bgcolor: transparent, align: right"]50562302001[/TD]
[/TR]
</tbody>[/TABLE]

I can do the split manually, but I would like to do it as soon as I scan the text in from the barcode.

Thanks
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]




[/TD]
[/TR]
</tbody>[/TABLE]

 

[Redwolfx]

Will they always be 19 characters?

This assumes the first scan in A1

In Column 2

=Left(A1,8)
Drag Down


In Column 3

=Mid(A1,9,11)
Drag Down

 

[rickh606]

That worked, thanks

 

[Redwolfx]

Glad to help. Thanks for the feedback