vba array remove numbers based on specific text content

[roykana]

Dear All master,


Please help me to make vba code. What I want in the bca sheet in column B which

only contains "KR AUTOMATIC LLG" then the numbers are removed and I have marked yellow.
LINK

vba array remove numbers based on specific text content.xlsm

drive.google.com

Thanks

roykana

result :

 

[roykana]

Dear All master,


Please help me to make vba code. What I want in the bca sheet in column B which

only contains "KR AUTOMATIC LLG" then the numbers are removed and I have marked yellow.
LINK

vba array remove numbers based on specific text content.xlsm

drive.google.com

Thanks

roykana

result :

only contains "KR OTOMATIS LLG" then the numbers are removed and I have marked yellow.
I corrected the contents in the cell.

Thanks

Roykana

 

[Fluff]

Duplicate to: VBA array make value from FormulaR1C1

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.