Extracting data

[baggarwal]

Just a quick question.

I have the following in two cells
Toronto Branch
Dallas Branch

I just want to extract Toronto and Dallas from the two cells. How do i do that?

 

[DominicB]

Good afternoon

If your first string is in A1, then this formula copied down will do the trick :

=LEFT(A1,LEN(A1)-7)

HTH

DominicB

 

[baggarwal]

This did not work. I just want to chop off the Branch from all regions. Can someone help.

 

[DominicB]

Hi baggarwal

The formula works fine for me - it chops off the last 6 characters of each cell = removing the word branch.

What cells are your data in?

DominicB

 

[baggarwal]

Thankyou so much for the formula. The problem was the data had some spaces which caused some problems.

 

[agihcam]

try the find and replace function.