Single value in multiple value

V

vibhor sanjar

New Member
Joined
Nov 5, 2007
Messages
11
Hiiii....

This is the third time I am posting my problem. Please help in by solving my proble. I want to convert single value in a cell in multiple value in the same cell. I also want to define a delimiter in the same cell.

Also don't want to use split function as it creates different cells.

For Example: "34,654, 5667, 566" is a value in the same cell. Excel takes it as a single value, how do I make excel to take it as multiple value in the same cell.


Plzzzzz.... help me for the same....
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
Hi

Look at the UDF called "GetElement" here.

You can then use a formula to reference any segment of the cell.

E.g.

=(GETELEMENT(A3,3,",")+0)+(GETELEMENT(A2,3,",")+0)

This will add the 3rd number element from both A2 and A3 where delimited by a comma.

Regards
Jon
 
Upvote 0
What is it that you want to do with these values all in one cell once you have separated them into seperate values?
 
Upvote 0
Why, in that case, do you need Excel to recognise them as seperate values? Surely doing a filter on a certain combination of the numbers as a single text string would achieve the same result.
 
Upvote 0
Right, but when you have different values in a same cell, excel take them as a single value and filtering is done taking that value as a single value.

For eg " 324, 564, 876" and " 324, 543, 654" are the values in two different cells. If I want filter for "324" only, excel won't allow it. and in case the data is huge then it becomes very tedious.

I hope, you are getting wht I mean.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Clear contents of cell if value is present in specified column on different excel sheet
Replies
5
Views
332
Akuini
Akuini
C
  • Question
Pasting time values will not sum total, typing will.
Replies
9
Views
320
Joe4
Joe4
S
  • Question
Extracting text within varying length phrases
Replies
8
Views
896
Peter_SSs
Peter_SSs
S
  • Question
Finding first date prior to another which is a multiple of a certain number of months.
Replies
2
Views
330
SYKEMAKAVELI
S
M
  • Question
return multiple cell values based on multiple criteria
Replies
1
Views
504
mumps
mumps

Forum statistics

Threads
1,215,409
Messages
6,124,737
Members
449,185
Latest member
hopkinsr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top