Adding a character to column if column doesn't already end in same character

Column B is file path. In order for our system to recognize this they must end in a /. However if you just copy the file path then it won't end in the /, meaning that employees have to manually go in and add that. Super minor i know, but we have several people doing this for hundreds of documents a day. It adds up. How can I do a test that says if in column B the cell doesn't end in a /, then add one?


I can't just do it to all of B because this worksheet is updated throughout the day and therefore rows 1-100 may already have the / but rows 101-150 do not. The file paths aren't the same either.

Attached is a workbook in case it helps anyone. Just really,

If doesn't end in "/" then add "/", Else nothing, apply to the last used row.

Playing with this, but this doesn't go down the column either

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

"Master" is the Sheet name. but you used the syntax for a sheet's codename ("Sheet1" in this case). So either:

Please Login or Register  to view this content.

...or:

Please Login or Register  to view this content.

Glad I could help! If that concludes your thread, please remember to mark it as SOLVED (Thread Tools above post #1). Regards - Lee

Originally Posted by jindon

Please Login or Register  to view this content.

Worksheet.Evaluate vs. Application.Evaluate...VERY COOL! Unqualified references are an issue with the latter, nice to know there's a "friendlier" version. AND it's apparently faster, too. Thanks for showing me something new. - Lee