Hi All,
I have a data in below format in a Row. I need Alphabets in a column with out any gap.
Kindly send me the excel 2010 or 2013 compatible formula.
Data in Row - 1 30 40 A 3 40 55 B 44 50 6 K 2 7 88 M
Data needed in Column as
A
B
K
M
Thanks in Advance
Regards
Subhash A.
Hello Subhash A.,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
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]
This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks