ExcelBanter - how to split abc123 into abc 123?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to split abc123 into abc 123? (https://www.excelbanter.com/excel-worksheet-functions/115443-how-split-abc123-into-abc-123-a.html)

Anna

how to split abc123 into abc 123?

i need to sort by 4th char. or split the data into two different colm.

Dave F

how to split abc123 into abc 123?

=LEFT(A1,3) assuming your data is in A1.

=RIGHT(A1,3) assuming your data is in A1.
--
Brevity is the soul of wit.

"Anna" wrote:

i need to sort by 4th char. or split the data into two different colm.

Anna

how to split abc123 into abc 123?

thank you so much, i just figured it out.

"Dave F" wrote:

=LEFT(A1,3) assuming your data is in A1.

=RIGHT(A1,3) assuming your data is in A1.
--
Brevity is the soul of wit.

"Anna" wrote:

i need to sort by 4th char. or split the data into two different colm.

Teethless mama

how to split abc123 into abc 123?

DataText to Columns

"Anna" wrote:

i need to sort by 4th char. or split the data into two different colm.

All times are GMT +1. The time now is 12:51 PM.