$$Excel-Macros$$ Re: Need excel formula for text to columns by " - " not "-"

I ended up replacing " - " with "*" and then used "*" as the deliminator On Friday, November 6, 2015 at 10:04:57 AM UTC-5, drew...@gmail.com wrote: > > Hello, > > I would be very grateful if someone could provide a formula for dividing > text to columns using " - " as a deliminator. > > Many Than

Re: $$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

Excel 2007, but it only allows for one character not three On Friday, November 6, 2015 at 11:23:11 AM UTC-5, Paul Schreiner wrote: > > What version of excel are you using? > > If it is Excel 2007 or later, there is a text-to-columns option in the > "Data" tab. > > If you're looking for a VBA fun

$$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

Hello, I would be very grateful if someone could provide a formula for dividing text to columns using " - " as a deliminator. Many Thanks, Andrew -- 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 @ htt