Hi, I have data in a field with city name then slash , ie perth/my shop name
I have a few hundred records and cant figure how to delete the city name and forward flash from each field. I tried replace option with *./ and it didn't work.
Can anyone please help
Hello & Welcome to the forum,
Give this a try...
=LEFT(A1,FIND("/",A1)-1)
find replace should work
find */
replace nothing
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks