Hello
I have a list of 2,000+ cells and they are filled with numbers like 1,10,6,3,16, in column C.
I'm trying to extract each number to the next cell over i.e. D1 = 1 E1 = 10 F1 = 6 G1 = 3 H1 = 16
I am able to get the first number using =LEFT(C25,FIND(",",C25,1)-1) , but I have no idea how to get find to recognize the
second, third or fourth occurrence of a comma.
Maybe I'm approaching this the wrong way...
davidmg_13,
Why not just use Text to Columns with comma as the delimiter?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try Data - Text To Columns
Deliminated - Next
Select Comma
Finish
Forgot to include a link for how-to:
http://support.microsoft.com/kb/214261
yes of course, ugh I feel like I wasted your time tigeravatar lol thank you I appreciate it
Thank you Jonmo1, that's exactly what I needed.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks