Is it possible to look for 2 values when using the Find function?
For example Request and request
(apologies if in the wrong location)
I stumbled across a first letter upper function yesterday! =CapFirstLetter(DATA CENTRE) would return "Data Centre"
Hopefully you'll also be able to put a column name in there as well and have it work for all entries in that column.
Julie Batty, I just took a look at trying to do multiple values in the Find function, and I do not believe you can. Having said that, you can make your formatting consistent by using Upper() within a new column, and use the find against that value instead. Hope that helps!
Thanks Shelby That's what I've thought of doing but more as a last resort - is there a way of making all first letters in a string of text upper?
hmmm there isn't a specific function that only uppercases the first letter, but there are still many ways to achieve that result.
Here's a scenario that works, excuse my column names
ztest will be "Request" in table
Great thanks Shelby
Oli you are a star, worked perfectly
Fantastic! Glad I could help
Retrieving data ...