Home » Forums » Open Source Learning Center » Question and Answer

FORUMLA HELP

Submitted by BLUEY on 7 June, 2014 - 09:58

I want a formula to take the information from cell A (1;12) and cell B (7.75;6.95) and put it into cell C as (1 £7.75 12 £6.95), is this possible ?

‹ prepare a .csv file for UL to HikaShop Importing email customer service changes into Excel workflow worksheet ›
»

Solution

Submitted by Tanujkumar88 on 9 June, 2014 - 18:19.

Hi,

Use this function for your result.. May be it work for you..

="("&MID(A1,2,FIND(";",A1)-2)&" £ "&MID(B1,2,FIND(";",B1)-2)&" "&MID(A1,FIND(";",A1)+1,(LEN(A1)-(FIND(";",A1)+1)))&" £ "&MID(B1,FIND(";",B1)+1,(LEN(B1)-(FIND(";",B1)+1)))&")"

Just copy paste in Cell C1.

Thanks
Tanuj

»