help me to resolve my problem
please give instructions to resolve this problem
Delhi 695143,695146,695147
Mumbai 695001,695002,695003
the places is entered in a1,a2 and the PIN nos of delhi in b1, PIN of mumbai in b2. i want split this content as
Delhi 695143 (A1,B1)
Delhi 695146 (A2,B2)
Delhi 695147 (A3,B3)
Mumbai 695001 (A4,B4)
Mumbai 695002 (A5,B5)
Mumbai 695003 (A6,B6)
How about ..
Data--Text to Columns--Delimited by ---'space' and repeat
Data--Text to Columns--Delimited by ---'comma'
Life's a spreadsheet, Excel!
Say thanks, Click *
multiple selection of cells for text to column is not allowed. without the place name its applicable with text to column
Dont understand thatmultiple selection of cells for text to column is not allowed. without the place name its applicable with text to column
You could do this at one go...
Data--Text to Columns--Delimited by ---'comma' as well as 'space'
Delhi 695143 (A1,B1)
Delhi 695146 (A2,B2)
Delhi 695147 (A3,B3)
Mumbai 695001 (A4,B4)
Mumbai 695002 (A5,B5)
Mumbai 695003 (A6,B6)
please check the cell no. i want to be listed in this format
Will this data
Delhi 695143,695146,695147
Mumbai 695001,695002,695003
be in 1 cell for each row?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Try this workbook using native formula and helpers.
As Ace_XL states in Post #4, You could avoid the formulae in C:I by using text to columns.
Note
K2 is a "starter" Value to base the adjacent formulae on.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
place and pin nos are in different cells
In that case, same idea, slight variation.
Hi
take a look at this
Please Login or Register to view this content.
Last edited by tom1977; 08-10-2012 at 03:03 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Should be
Please Login or Register to view this content.
Last edited by jindon; 08-10-2012 at 03:46 AM.
Try this one.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Now that is really impressive!
Typing over a thousand characters to create two loops, to do what 4 formulae can do ...
Okay, so why do things the easy way when there is a complicated option? ...
@marcol
I'm interested to whom you responding.
baishi,
Thanks for the appreciation, but you should mark this thread as "Solved", too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks