Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to split text in Google spreadsheet or excel?

    • 1
    • 0
    • 0
    • 0
    • 0
    • 0
    • 2
    • 0
    • 736
    Comment on it

    Many time we need to split the data in our spreadsheet for this we can use SPLIT formula

    lets take an example,

    I have a large set of data which includes mail address like, sachin@gmail.com, findnerd@abc.com

    in column A, so if I need to split the text from @ I will use the below formula.

    =SPLIT(A2, "@")

    according to above formula A is the column and 2 is the row and @ is the text from where I am splitting the data.

    For more see the screen shot below:

    In the above screenshot you can clearly see that, I have used the formula to split the text from @, you can change the formula according to your data, i.e if you have comma (,) in your data and you want to split the data from comma (,) so in place of "@" you just have to put comma (,).

     

    Output will be:

    In the above screenshot you can clearly see that output in column B and C, the text has been splitted form "@".

    How to split text in Google spreadsheet or excel?

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: