Projecting numbers into various cells from a bunch of numbers in single cell

**LAVA2** · 05-28-2018, 04:27 AM

Hi,

I Did copied & pasted a bunch of values "1,3,4,2" as it is from some website in cell S2. Now I would like that 1 to be in cell s3 , 2 in cell s4, 3 in cell s5 and 4 in cell s6 in ascending order, so that it would be possible to add, subtract and multiply those four numbers later as desired.

But the problem is that whenever i press S2 it displays the whole bunch 1,2,4,2 in the formula bar and i do not know how to proceed forward to achieve above stated result. Thus any ideas suggested will be very much appreciated.

Thank you

**samba_ravi** · 05-28-2018, 06:30 AM

S3=IFERROR(SMALL(INDEX(--TRIM(MID(SUBSTITUTE(S$2,",",REPT(" ",LEN(S$2))),(ROW(INDIRECT("1:"&LEN(S$2)-LEN(SUBSTITUTE(S$2,",",""))+1))-1)*LEN(S$2)+1,LEN(S$2))),0),ROWS(S$3:S3)),"")

Please Login or Register  to view this content.

Try this and copy towards down

**Greg M** · 05-28-2018, 06:44 AM

Hi there,

See if the attached workbook does what you need. It uses the following VBA User-Defined Function:

Please Login or Register  to view this content.

To use the function, enter the following formula in the appropriate cell:

Please Login or Register  to view this content.

where SourceCell is the address of the cell which contains e.g. "2, 1, 7, 3"

and ValueNo is whichever of the individual values (e.g. Value No 3) you wish to display.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Projecting numbers into various cells from a bunch of numbers in single cell

LinkBack

Thread Tools

Rate This Thread

Display

Projecting numbers into various cells from a bunch of numbers in single cell

Re: Projecting numbers into various cells from a bunch of numbers in single cell

Re: Projecting numbers into various cells from a bunch of numbers in single cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Needing to transpose a bunch of numbers??????

[SOLVED] Count the numbers within a string of numbers in a single cell

[SOLVED] Split data in one single cell to multiple cells with Numbers as delimiters

Conditional Formatting of cells with a range of numbers in the single cell referenced

[SOLVED] Copy multiple numbers from a single cell to individual cells

[SOLVED] i have a data with numbers with letters in single cell , i need to split numbers and names

[SOLVED] I want merge all numbers in single cell with , between numbers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions