Left & right function

[De Bruce]

Good day all,
I'm trying to chop off 9 characters starting from the left in a cell,
when I use the "LEFT FUNCTION" excel returns the 9 characters
chopped off. But I want excel to chop off 9 characters from the left and returns the remaining characters to the right. However, I can't achieve this with the "RIGHT FUNCTION" because the number of characters to the right varies. Please i need the exact function to chop off 9 characters to the left and the remaining characters to the right will be returned
Example below:
Cell E3 = HP Deskjet 1510 series (Copy 1) on Ne14:
I need to chop off " on Ne14:" and return "HP Deskjet 1510
series (Copy 1)" to Cell E5.
Thanks In Advance
De Bruce.

 

[bosco_yip]

In E5, enter :

=LEFT(E3,LEN(E3)-9)

Regards
Bosco

 

[De Bruce]

Thanks Bosco, it really worked well.
You made my day, thanks

 

[De Bruce]

Hi Bosco,
I don't know if you can assist with this

I have a command button titled "LOW STOCK" on my userform, I want the back color of this button to switch between yellow and salmon when Cell G3 > 0 (Cell G3 contains number of products below stock minimum limit).
The blinking will prompt the user to click the button inorder to display (via a pop up message box) numbers of products having low stock.
I inserted the code below in Userform_Initialize, but excel freezes up and displays on the title bar "Excel is Not Responding". Please I'll be glad to know where I went wrong, thanks in advance.

Sub Userform_Initialize
Do while sheet1.Cells(3, 7) > 0
btnLowStock.Backcolor = RGB(255, 255, 0)
btnLowStock.Backcolor = RGB(255, 128, 128)
Loop
End Sub

 

[Joe4]

Hi Bosco,
I don't know if you can assist with this

I have a command button titled "LOW STOCK" on my userform, I want the back color of this button to switch between yellow and salmon when Cell G3 > 0 (Cell G3 contains number of products below stock minimum limit).
The blinking will prompt the user to click the button inorder to display (via a pop up message box) numbers of products having low stock.
I inserted the code below in Userform_Initialize, but excel freezes up and displays on the title bar "Excel is Not Responding". Please I'll be glad to know where I went wrong, thanks in advance.

Sub Userform_Initialize
Do while sheet1.Cells(3, 7) > 0
btnLowStock.Backcolor = RGB(255, 255, 0)
btnLowStock.Backcolor = RGB(255, 128, 128)
Loop
End Sub

Duplicate: https://www.mrexcel.com/forum/excel-questions/1100015-do-while-loop-post5288740.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will typically be locked or deleted (rule 12 here: Forum Rules).