Formula of the day : Formula to split text to columns by pipe sign

3 views
Skip to first unread message

vabs

unread,
Apr 25, 2015, 3:12:58 AM4/25/15
to Excel...@googlegroups.com
If  you have text in one cell which is delimited by pipe sign & you want to split in to next cells one by one then you can use formula:

=TRIM(MID(SUBSTITUTE($A2,"|",REPT(" ",99)),(COLUMN(A2)*99)-98,99))

Refer attachment for reference.

Cheers!!
Formula to split text to columns.xlsx

Ashish Kumar

unread,
May 1, 2015, 1:54:04 AM5/1/15
to Excel...@googlegroups.com
Thanks for Sharing ....!!

Nice formula....!!



Regards
Ashish Kumar

Ashish Kumar

unread,
May 1, 2015, 3:05:49 AM5/1/15
to Excel...@googlegroups.com
Dear Vaibhav Bhai,,, It's Superb Formula.


Regards
Ashish Kumar

On Saturday, April 25, 2015 at 12:42:58 PM UTC+5:30, vabs wrote:
Reply all
Reply to author
Forward
0 new messages