Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
11
Views
Topic starter
I am using "equal" formula for from sheet1 and sheet2.
I have attached the video below Please watch and help me out Please.
It's very simple, but I don't have much knowledge. Please help
Posted : 18/03/2021 7:21 am
Hi Syed,
If the aim is to get the string West Broad Hyundai from the string New Site - West Broad Hyundai on Sheet 2 then just use this formula in your cell on Sheet1.
=MID(Sheet2!B3,FIND("-",Sheet2!B3)+2,LEN(Sheet2!B3)-FIND("-",Sheet2!B3))
Regards
Phil
Posted : 18/03/2021 10:55 pm
