i have a sheet with cells that have this format
abchhdh_dsfsdf_sdfsdf_asd_dd_adfdf_fff .....
i dont know the number of underline in each cell
and i dont know how many characters are betwin two underline
how i can seperate each cell for example i want to make below format
"abchhdh" in one cell ,in the next cell "dsfsdf" ,in the next cell "sdfsdf" and so on
many thanks
Please change your title first to something more descriptive of the problem
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
majidzf
Please read forum rules (rule 1) & use suitable thread titles
A thread with the rules is available at the top of each forum or see link below for rules
Closing this thread.
You are welcome to repost using a valid thread title
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks