Excel (OpenOffice Calc, actually)

[rivan]

I'm trying to twink some data but really have no clue how to write the formulas. The final results need to be exported as a .csv

I have columns F and G - FirstName and LastName.

I need to generate two new fields:

First.Last

and

XY

where X is a constant string and Y is the number of characters in LastName.

Color me clueless in Calc.

 

[mayest]

To generate First.Last do this:

=F1&"."&G1

For the other one, I'm not clear on what you want, but something like this should do:

="X"&Text(Len(G1),"#")

You'll need to use the Text() function to convert the string length to a string. The "#" is the format mask, and basically says show the integer without any decimal places.

 

[rivan]

Excellent, thank you.