Groups
Groups
Sign in
Groups
Groups
Excel VBA Lab - An Excel VBA Macro help Group
Conversations
Labels
About
Send feedback
Help
Formula of the day : Formula to split text to columns by pipe sign
3 views
split
texttocolumnformuala
Skip to first unread message
vabs
unread,
Apr 25, 2015, 3:12:58 AM
4/25/15
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 AM
5/1/15
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Excel...@googlegroups.com
Thanks for Sharing ....!!
Nice formula....!!
Regards
Ashish Kumar
Ashish Kumar
unread,
May 1, 2015, 3:05:49 AM
5/1/15
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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