Forum

I want to copy the ...
 
Notifications
Clear all

I want to copy the text from Sheet2 from Sheet1 (Dynamic text) Please watch attached video below

2 Posts
2 Users
0 Reactions
74 Views
(@bashaali1306)
Posts: 1
New Member
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
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

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
Share: