Please help clean my errors...
My spreadsheet does fine until I get to the 9th name "De La Garza, Anthony"
My goal is to help a teacher make a seating chart with little work from her. She needs to be focused more on teaching the students.
See the attached spreadsheet to see my intentions. "ALL NAMES AND NUMBERS HAVE BEEN CHANGED, THESE ARE FICTIONAL STUDENTS"
Thank you all,
Jay
Last edited by jltjr75; 08-25-2019 at 03:47 PM. Reason: Solved my problems!
What exactly does this mean?
What is it not doing fine at that point? I cannot see that the spreadsheet is doing anything much at all - what exactly are you trying to achieve?My spreadsheet does fine until I get to the 9th name "De La Garza, Anthony"
EDIT: Oh, I see now!
This in C3 copied down:
=TRIM(LEFT(SUBSTITUTE(MID(B3,FIND(",",B3)+2,99)," ",REPT(" ",99)),98))
Last edited by AliGW; 08-25-2019 at 03:05 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
That's perfect! How do I prevent that "#VALUE!" error from showing using the formula?
Wrap Ali's formula in iferror…
=iferror(TRIM(LEFT(SUBSTITUTE(MID(B3,FIND(",",B3)+2,99)," ",REPT(" ",99)),98)),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Great response time. Thank you so much. It worked beautifully!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks