Question description:
This user has given permission to use the problem statement for this
blog.
Can you re edit this formula for me =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Solved by S. L. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/07/2018 - 05:59
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
User
02/07/2018 - 06:00
Can you re edit this formula for me so that it works without IFERROR =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Excelchat Expert
02/07/2018 - 06:01
Sure thing! I should just remove the IFERROR then
Excelchat Expert
02/07/2018 - 06:01
Without the IFERROR, it will be like this:
Excelchat Expert
02/07/2018 - 06:01
=IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1))
User
02/07/2018 - 06:03
?
Excelchat Expert
02/07/2018 - 06:03
I took out the IFERROR function and had the previous formula as the result. Is the modified version working?
Excelchat Expert
02/07/2018 - 06:05
Please do ping me if there seems to be an error with the modified formula.
User
02/07/2018 - 06:08
Can you send me the modified version
Excelchat Expert
02/07/2018 - 06:08
=IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1))
Excelchat Expert
02/07/2018 - 06:08
This is the modified version without the IFERROR function.
User
02/07/2018 - 06:09
I need it to not include IF as well
Excelchat Expert
02/07/2018 - 06:09
If that will be the case, the formula will be divided into two.
Excelchat Expert
02/07/2018 - 06:10
The TRUE condition of the IF would be =LEFT(B4,3)
Excelchat Expert
02/07/2018 - 06:10
The FALSE condition would be =MID("RHS",1,FIND("RHS",B4,1))
User
02/07/2018 - 06:12
can you put them together
Excelchat Expert
02/07/2018 - 06:13
We would need the IF statement to put them together. I further modified the previous first formula. Please do check the one below if it works:
Excelchat Expert
02/07/2018 - 06:13
=IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1)))
User
02/07/2018 - 06:14
ok
User
02/07/2018 - 06:14
I have tried that but it doesnt work
User
02/07/2018 - 06:14
even with the IF statement
Excelchat Expert
02/07/2018 - 06:16
I see. WIll it be okay if you could share the file you're working on. I would like to see how the cells are referenced so I could diagnose the formula more. Thanks!
Excelchat Expert
02/07/2018 - 06:17
Just to clarify, is an error being produced if you enter the IF statement in your file?
User
02/07/2018 - 06:17
yes
User
02/07/2018 - 06:18
what is your email address
Excelchat Expert
02/07/2018 - 06:18
I see. It seems the IFERROR then is essential. Oh, unfortunately we aren't allowed to share personal info within this platform. You maybe able to upload the file via the clipboard icon to the right of this chatbox.
User
02/07/2018 - 06:19
no that doesnt work
Excelchat Expert
02/07/2018 - 06:20
Or you could as well upload your file via google sheets and share the link in here. This would allow me to access the file.
User
02/07/2018 - 06:20
https://docs.google.com/spreadsheets/d/1svjKqeLUzt5lzY3R2-SoSNGgxJu-t3V_n0ox83JyfBY/edit?usp=sharing
User
02/07/2018 - 06:20
quick please
Excelchat Expert
02/07/2018 - 06:20
I've sent an access request for the file. Please do accept. Thanks!
Excelchat Expert
02/07/2018 - 06:23
I see. It seems you need assistance in answering column I, which extracts the LHS and RHS of the column B description. Is this correct?
User
02/07/2018 - 06:23
yes
User
02/07/2018 - 06:23
quick
Excelchat Expert
02/07/2018 - 06:23
Sure thing, let me work on it the soonest.
Excelchat Expert
02/07/2018 - 06:26
Already done! Please see formulas under column I for your review. Should you have any queries, please feel free to ask.
Excelchat Expert
02/07/2018 - 06:32
Just to provide a simple explanation on how the formula works, you'll notice the ISERROR(FIND("LHS",B9)). This just means that the first attempt would be to find "LHS" in cell B9. If it can't be found there, the FIND function will return an ERROR. If this happens, then ISERROR(error) would be TRUE. If indeed this is TRUE, then meaning the answer would be "RHS" (since FIND("LHS" didn't come true). However, if the FIND("LHS",B9) indeed finds a value, then it will automatically return "LHS"
Excelchat Expert
02/07/2018 - 06:36
Hello! Were you able to confirm the solution provided? Thanks!
Excelchat Expert
02/07/2018 - 06:37
If there is no more concerns, You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great rating after this.Thanks so much for using Got it pro and have a nice day! :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.