LinkBack URL
About LinkBacks
Dear all, Data separation by formula
CELLA having data like below
I would like to get in the CELL B , CELL C, CELL D
Please Login or Register to view this content.
Please Login or Register to view this content.
Dear all, Data separation by formula
CELLA having data like below
I would like to get in the CELL B , CELL C, CELL DPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by nur2544; 07-31-2014 at 02:06 PM.
B1:
=TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",100)),MAX((COLUMN(A1)-1)*100,1),100))
Copy over and down
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
hi daffodil11, Thanks for reply , yes i am getting desire output for CELL B, would you please work for CELL C , & CELL D . as i need total three formula for getting my desire output.
I would like to get in the CELL B , CELL C, CELL D
B1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(a1)-1)*100,1),100))
c1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(b1)-1)*100,1),100))
d1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(c1)-1)*100,1),200))
hi daffodil11, it works perfectly , my requirements is fulfillment now, thanks for your valuable time for me , I really appreciated your nice job…
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks