Merging two list boxes with fixed lenghth of charecters

[prasadreddy]

Hi All,

Below are my two list boxes in my task, and i want merge these two list boxes as One, with fixed length of 10 charecters,

Ex: First Name : John, Count from 'J' , 11th charecter should be 'K'

Ex: First Name : Karthikeyanraja Count from 'K', 11th charecter should be 'L'

First Name	Last Name
John Praveen Alexander Karthikeyanraja	K M G L

I want the result below

Result:

Full Name
John------K Praveen---M Alexander-G KarthikeyaL

Can any one help me on this please....

Thanks in advance

[#2]

Please find the attached application.

[prasadreddy]

Hi vankatreddy,

Please check my example once,

Including First name it should be 10 charecters, in 11th charecter it should be Last name

like below:

Full Name
John      K

KarthikeyL

Praveen   M

Between John & K, it has 6 blanks, so, 6 blanks and 'John' = 10 charecters

[jonathandienst]

Hi

This what you need:

Left([First Name] & '----------', 10) & Left([Last Name], 1)

Jonathan

[senpradip007 · Accepted solution]

Hi Prasad,

PFA.

[prasadreddy]

Thank you very much Pradip