SV650.org - SV650 & Gladius 650 Forum - View Single Post - Computer bod of the org- I need your help

Sir Trev · 28-06-11, 10:33 AM

Sounds like you need a simple "add together" formula. If it's a combination of text and name say (where the name is entered in another cell) and the text is constant use

=concatenate("text: ",b2)

If cell b2 has the word flange in it the result would be

text: flange

If the text is variable then slimply link two or more fields in exactly the same way, such as

=concatenate(c1,d1,e1)

That way you can set up a table and join two or more fields to get a single ID/reference if that's what you need.

Does that help?

28-06-11, 10:33 AM	#2
Sir Trev Member Mega Poster Join Date: Jun 2005 Location: High Wycombe, where the chair factories used to be Posts: 1,479	Re: Computer bod of the org- I need your help Sounds like you need a simple "add together" formula. If it's a combination of text and name say (where the name is entered in another cell) and the text is constant use =concatenate("text: ",b2) If cell b2 has the word flange in it the result would be text: flange If the text is variable then slimply link two or more fields in exactly the same way, such as =concatenate(c1,d1,e1) That way you can set up a table and join two or more fields to get a single ID/reference if that's what you need. Does that help? __________________ We are the Goon Squad and we're coming to town, BEEP BEEP!