Dear all, Data separation by formula
CELLA having data like below

3RB2       AIS     130719  13414056RB2                        RDI
               140619  124341872RB2          LOFYT
130619  1543466589RBL2                LOS                     120519
114346KL5252B          NONE                     150619  10434556RB2
                  EQUEP                     130619  174326872RB2
      NONEA        110619  194346DH012A
ERATE     130610  204342

I would like to get in the CELL B , CELL C, CELL D

CELL B    CELL C      CELL D3RB2        AIS     130719  134156RB2       RDI     
140619
1243872RB2      LOFYT   130619  15436589RBL2    LOS     120519
1143KL5252B     NONE    150619  104356RB2       EQUEP   130619
1743872RB2      NONEA   110619  1943DH012A      ERATE   130610  2043

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Reply via email to