I want to transpose or simply extract the numbers I have entered in a single cell for getting the sum. i.e In cell A1, I have given =1+2+3+4+5+6.
I want to extract these numbers in different rows or columns i.e A2 1, B2 2, C2,3 like that.
I want to transpose or simply extract the numbers I have entered in a single cell for getting the sum. i.e In cell A1, I have given =1+2+3+4+5+6.
I want to extract these numbers in different rows or columns i.e A2 1, B2 2, C2,3 like that.
Hi,
Select the column and format it as text. The use the Data TextToColumns functionality specifiying the '+' as the delimiter
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Or use formula
Enter in B2 and copy across
Formula:Please Login or Register to view this content.
v A B C D E F G 1 2 1+2+3+4+5+6 1 2 3 4 5 6 3
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks