Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,152,427 members, 7,815,964 topics. Date: Thursday, 02 May 2024 at 10:21 PM |
Nairaland Forum / Nairaland / General / Microsoft Excel Gurus In The House, Please Help (204 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)
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: |
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: 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: 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: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)
Nigeria Latest News From The Truth Dailies / Copywriting And Fiverr Master Class / Missingchild:have you seen sadiq
(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. 18 |