splitting up multiple values in a cell

[spidersweb10382]

I have always had good luck using this site as a resource and figuring things out on my own, and have more than once gotten help from everyone here when I couldn't find the answer. I come to you again in the hopes someone can help. My problem is simple but I cant wrap my head around the answer:

I have a report presents 4 values in one cell and I need to split it in to 4.

3 / 131 / 18 / 11

I pretty much just need to end up with 4 cells containing each value, without the use of VBA.

Thank you!

 

[Eric W]

If your value is in A1, put this formula in B1 and drag to the right as needed:

=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",200)),(COLUMNS($B1:B1)-1)*200+1,100))

 

[Momentman]

You can use Text to columns and Split based on "/" as your delimiter

 

[spidersweb10382]

Wow that was fast, and it appears to have worked like a charm! Thank you!

 

[Eric W]

Glad we could help!