Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,148,879 members, 7,802,840 topics. Date: Friday, 19 April 2024 at 10:59 PM

Microsoft Excel Gurus In The House, Please Help - Nairaland / General - Nairaland

Nairaland Forum / Nairaland / General / Microsoft Excel Gurus In The House, Please Help (200 Views)

To All The English Gurus In The House, This Is 4 U. / Gurus In The House Lets Solve This / BTC Gurus, How Do I Invest More? (2) (3) (4)

(1) (Reply) (Go Down)

Microsoft Excel Gurus In The House, Please Help by fikki1: 12:46pm On Apr 23, 2021
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.
Re: Microsoft Excel Gurus In The House, Please Help by oloriooko(m): 12:53pm On Apr 23, 2021
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.
Re: Microsoft Excel Gurus In The House, Please Help by degamonn: 1:21pm On Apr 23, 2021
Yes, I can, but what you want is not clearly stated yet.
Re: Microsoft Excel Gurus In The House, Please Help by fikki1: 3:22pm On Apr 23, 2021
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.
Re: Microsoft Excel Gurus In The House, Please Help by fikki1: 3:24pm On Apr 23, 2021
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
Re: Microsoft Excel Gurus In The House, Please Help by degamonn: 3:49pm On Apr 23, 2021
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.

(1) (Reply)

Let's Go Back To Pre-endsars Relationship _ Police AIG Begs Nigerians / 6-year-old Nigerian Boy Gets Dirty Working As An Auto Mechanic / Copywriting And Fiverr Master Class

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 12
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.