I recently exported a bibliography from word into excel via text. The titles, all between and have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where appears, i.e.a concatenate formula of varying columns?
Solved by T. Q. in 28 mins