₦airaland Forum

Please house,
Can you help me separate text(data) in a cell in excel with a specific formula.

For example;

BEBRUATWTPEAAEM10111031000167 (all in cellA1)

Into

BEBRUA TWTPEA A EM 10111 031 000167 (all in cellB1)


Note: normally I would space it, but it’s a lot. I have about 100 cells with different data as above.

Try google

fikki1:
Please house,
Can you help me separate text(data) in a cell in excel with a specific formula.

For example;

BEBRUATWTPEAAEM10111031000167 (all in cellA1)

Into

BEBRUA TWTPEA A EM 10111 031 000167 (all in cellB1)


Note: normally I would space it, but it’s a lot. I have about 100 cells with different data as above.

Yes, I can, but what you want is not clearly stated yet.

degamonn:
Yes, I can, but what you want is not clearly stated yet.

Thanks bro,

Let me explain better;

I have this below in each cells of the worksheet, they are all different numbers. They are writing together, because there are auto generated.

BEBRUATWTPEAAEM10111012000277 (CellA1)
BEBRUATWTPEAAEM10111024000211 (CellA2)
BEBRUATWTPEAAEM10111022000187 (CellA3)
BEBRUATWTPEAAEM10111011000253 (CellA4)
BEBRUATWTPEAAEM10111017000197 (CellA5)
BEBRUATWTPEAAEM10111029000198 (CellA6)

up to CellA100, in different worksheets of 25


But I need space in-between them like this below

BEBRUA TWTPEA A EM 10111 027 000198
BEBRUA TWTPEA A EM 10111 033 000168
BEBRUA TWTPEA A EM 10111 031 000167
BEBRUA TWTPEA A EM 10111 030 000114
BEBRUA TWTPEA A EM 10111 060 000199
BEBRUA TWTPEA A EM 10111 061 000040
BEBRUA TWTPEA A EM 10111 026 000192
BEBRUA TWTPEA A EM 10111 025 000197
BEBRUA TWTPEA A EM 10111 036 000034


I was thinking if there is a formulae to space them so I can do it easily, rather than spacing it manually.

If you understand me.

oloriooko:
Try google

I tried bro, but not getting it.

- I got formula to split into two (left and right)
- Formulae to separate the figure
But not able to get what I want

fikki1:
Thanks bro,

Let me explain better;

I have this below in each cells of the worksheet, they are all different numbers. They are writing together, because there are auto generated.

BEBRUATWTPEAAEM10111012000277 (CellA1)
BEBRUATWTPEAAEM10111024000211 (CellA2)
BEBRUATWTPEAAEM10111022000187 (CellA3)
BEBRUATWTPEAAEM10111011000253 (CellA4)
BEBRUATWTPEAAEM10111017000197 (CellA5)
BEBRUATWTPEAAEM10111029000198 (CellA6)

up to CellA100, in different worksheets of 25


But I need space in-between them like this below

BEBRUA TWTPEA A EM 10111 027 000198
BEBRUA TWTPEA A EM 10111 033 000168
BEBRUA TWTPEA A EM 10111 031 000167
BEBRUA TWTPEA A EM 10111 030 000114
BEBRUA TWTPEA A EM 10111 060 000199
BEBRUA TWTPEA A EM 10111 061 000040
BEBRUA TWTPEA A EM 10111 026 000192
BEBRUA TWTPEA A EM 10111 025 000197
BEBRUA TWTPEA A EM 10111 036 000034


I was thinking if there is a formulae to space them so I can do it easily, rather than spacing it manually.

If you understand me.

I may not have time to give detail function that can work out. I think a combination of trim/space function can assist you to a certain extent.