Characters

[#1]

Can anyone please help me. I'm creating a bar chart to show sales and I've got Names of stores here, however, they all start with the same name. It is 7 characters long then a space and then the name. eg.

Georges Muffins

And i want to get rid of Georges and just keep Muffins. How do I go about doing that? I have 6 stores.

Any help will be greatly appreciated.

[brenner_martina · Accepted solution]

Hi Blaze,

here helps the same stringfunction:

Right(Fieldname,Len(Fieldname)-8)

[#3]

Awesome thanks so much

[johnw]

Also:

mid(Fieldname,9)
subfield(Fieldname,' ',2) // Still works even if the store lengths are variable