I have some mixed kind of data likewise " text 1234 text 4567 text 7654" and I want the the numbers arranged either on the left side or side of the cell. How can I do that?
I have some mixed kind of data likewise " text 1234 text 4567 text 7654" and I want the the numbers arranged either on the left side or side of the cell. How can I do that?
Last edited by nadimqaisar; 08-25-2015 at 10:35 AM.
So you want "123445677654 texttexttext"?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
1234 4576 7654 text text text..... like this
Any sort of patterns?
Always 3 sets of numbers and text?
Always sets of 4 digits? If not, what range?
Always "# space text space # space text space number space text"?
Any specific number of or range of characters in the text?
This is the issue that there is no set pattern. Numbers can appeat multiple times, text can appear multiple times. No set pattern. Text can appear any where, number can appear any where. Range is also not fixed. The same or different combination can appear in multiple cells.
Last edited by nadimqaisar; 08-25-2015 at 12:04 PM.
Are you opposed to a UDF (User Defined Function requireing VBA)
Here is a spreadsheet with a UDF. The name of the UDF is NumsFirst so would use it just lke a normal function =NumsFirst(A1)
The code isPlease Login or Register to view this content.
Last edited by ChemistB; 08-25-2015 at 01:40 PM.
Thank you so much sir for your generous support. Will test this once I reach office and let you know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks