Hi everyone
in my excel file, in cell A1, I wrote this text: (there is a space between each word)
Vlookup Index Offset Match
I want to separate each word in cells B1:F1 with an array formula
How?
Thanks
Hi everyone
in my excel file, in cell A1, I wrote this text: (there is a space between each word)
Vlookup Index Offset Match
I want to separate each word in cells B1:F1 with an array formula
How?
Thanks
Why do you feel that it should be an array formula?
Pete
Using your example, this regular formula copied across to the right, parses the A1 text into individual words per cell
Is that something you can work with?Please Login or Register to view this content.
because I feel that I can't write a normal formula with drag it to adjacent cells.
can you write it without array formula?
Ron has already supplied you with one.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks