Hi Prabhu,
see if the enclosed file helps
Regards
Umesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
> But below formula is not working.
>
> Kind do the needful.
>
>
> --
>
>
Hi Prabhu,
Try the below formula in cell B2.
=TRIM(SUBSTITUTE(A2,CHAR(160),""))
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)
*
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
HI Prabhu,
You can use the trim command...
and another solution is that u can use 'Text to columns' action under 'Data'
menu and then take fixed width...
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
>
Hi Prabhu
Try
'=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))
http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-beginning-and-end-of-a-cell-HP003056131.aspx
Thanks
Mahesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains sp
Hi Friends,
I have attached a sheet, which contains space in prefix and suffix.
But below formula is not working.
Kind do the needful.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips t
