Fwd: Query

IAT Institute

unread,

Feb 21, 2016, 12:21:33 PM2/21/16

to iat-...@googlegroups.com

---------- Forwarded message ----------
From: Sumit Rawat <smtra...@gmail.com>
Date: Tue, Feb 9, 2016 at 12:27 PM
Subject: Query
To: contac...@gmail.com

Hi Team,

Please try to solve this query i want out put in below mention formate.

Kranti Srivastava

unread,

Feb 22, 2016, 2:27:16 AM2/22/16

to IAT Institute, iat-...@googlegroups.com

=PROPER(RIGHT(A1,2) & " " & SUBSTITUTE(A1,RIGHT(A1,2),""))

Provided data is in cell A1.

--
You received this message because you are subscribed to the Google Groups "Advance Excel Group - IAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iat-info+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Sumit Rawat

unread,

Feb 22, 2016, 3:18:34 AM2/22/16

to Kranti Srivastava, IAT Institute, iat-...@googlegroups.com

Vaha kranti bhai

Thanks

Kranti Srivastava

unread,

Feb 22, 2016, 6:19:13 AM2/22/16

to Sumit Rawat, iat-...@googlegroups.com, IAT Institute

Bhai starting me trim Bhi laga de

Sent from my iris X5

Reply all

Reply to author

Forward