I have a bunch of accounts i am extracting from my companies database, in the database we have the suite # keyed into the address field.
I am importing those addresses into a route planner but it will not accurately locate the accounts with the suite # in the fields.
For example:
Cell C6 reads (1200 SE 28th St, Ste 2)
How can i formulate something to remove (, Ste) and the following number throughout the entire workbook.
Thanks
Is the ", Ste #" text always the last part of the cell value?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi,
One way,
Use a helper column with
Formula:
Please Login or Register to view this content.
copied down then copy this helper result back as values to the original range.
Alternatively do a Find for "Ste* " and replace with nothing.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=LEFT(C6,FIND(",",C6,1)-1)
Try this formula
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Hello tward please upload a workook
in cell d6 you can enter = left(C6,find(",",C6)-1) and drag down
but it would be better if you can upload a book
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
That formula works. Thanks all for the help.
Tward
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks