Triming the Name

[sjpras]

Hi Excel Gurus,

I 1000 odd long name appearing and I want to trim it through excel formula. Please help

Example: Like this I have a name set like

Row1 - Marcas du felo, rodriges -
Row2 - dosedat ju foris, anjelo -
Row3 - gosentti di, maria -

Need a formula just to show Marcas, dosedat, gosentti
Thanks

[NeedForExcel]

Assuming your name is in A1, put this in B1. Drag down as required.

=LEFT(A1,FIND(" ",A1)-1)

[sjpras]

It worked. thanks a lot

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

Use GetText() function in excel cell by passing the input range like the below

=GetText(A1:A3)

[NeedForExcel]

Glad it helped!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.