Need Predefined Formula for Text To Column

[Debraj]

Hi EXCELians,


In Cell A1 'A549_CL130497_SAM602138_Batch100_Plate_5_H4'


In VBA > UDF

[pre]

Function TextToColumn(Text As String, Separator As String)
TextToColumn = Split(Text, Separator)
End Function[/pre]
In Cell A3 to G3 formula {=TextToColumn(A1,"_")}

(Ctrl+Shift+Enter)


Question:

Do we have any predefined formula in Excel corresponding to

Split or TextToColumn..

or to separate a Text in Column/Row..

 

[NARAYANK991]

Hi Debraj ,


I don't think there is a single native Excel worksheet function which can do the job. You can use formulae to do this however. Have you checked these out ?


http://chandoo.org/wp/2008/09/08/split-text-excel-functions/


http://www.get-digital-help.com/2011/03/23/text-to-columns-split-words-in-a-cell-excel-array-formula/


Narayan