RE:NewColumn

[Chanty4u]

Hi all,

I have excel with below data i need txt as new column in  excel .

i tried   =RIGHT(F:F,3)     but it is givng  0.8 ,0.,5.2   lik dat

expected out put:

cts

cts

cts

cts

pcs

[Anonymous]

Try this:

=trim(right('62300.800 cts',Len('62300.800 cts') - Index('62300.800 cts',' ')))

substitute '62300.800 cts' with your Field Name

[Gysbert_Wassenaar · Accepted solution]

My guess is that the values in your excel file do not actually contain string values like cts and pcs, but that those are only formatting. If that's the case then you will have to change the values in excel to add the cts and pcs strings.

[Anonymous]

the above can be done in Qv in your load statement

Load *,

trim(right(Quantity,Len(Quantity) - Index(Quantity,' '))) As Measure

from yoursource..

[sunny_talwar]

I agree with Gysbert, the units might be part of the formatting rather than the value itself which might be causing this issue. Can you share your Excel file to look at it?

[Chanty4u]

thank you.  issue got resolved.

used function

=GET.CELL(Column,'SheetName')

And  =Right(Columnname,Length)

[Chanty4u]

let me try tommorow