Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In

Have an account? Sign In Now

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

Get Up Genie

Get Up Genie Logo Get Up Genie Logo

Get Up Genie Navigation

  • Home
  • About Us
  • Contact Us
Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Terms of Use
  • Terms of Use
  • Privacy Policy
  • Privacy Policy
  • Cookie Policy
  • Cookie Policy
Home/ Questions/Q 26546
Next
In Process

Get Up Genie Latest Questions

todaytech
  • 0
  • 0
todaytech
Asked: August 3, 20242024-08-03T10:58:16+00:00 2024-08-03T10:58:16+00:00In: Technology

How to separate the website name and URL into two separate cells in Excel?

  • 0
  • 0
How to separate the website name and URL into two separate cells in Excel?
separate the website name and url into two separate cells
1
  • 1 1 Answer
  • 39 Views
  • 0 Followers
  • 0
    • Report
  • Share
    Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
    • Share on WhatsApp

Leave an answer
Cancel reply

You must login to add an answer.

Forgot Password?

Need An Account, Sign Up Here

1 Answer

  • Voted
  • Oldest
  • Recent
  • Random
  1. todaytech
    todaytech
    2024-08-03T10:58:43+00:00Added an answer on August 3, 2024 at 10:58 am

    To separate the website name and URL into two separate cells in Excel, you can use the Text to Columns feature or an Excel formula.

    Using Text to Columns Feature:

    Select the column containing the data (e.g., A1:A100).
    Go to the Data tab.
    Click on Text to Columns.
    Choose Delimited and click Next.
    Check the Comma delimiter and click Next.
    Choose the destination cells where you want the split data to appear.
    Click Finish.
    Using an Excel Formula:

    Assuming your data is in column A starting from cell A1, you can use the following formulas to separate the website name and URL into two columns:

    In cell B1 (for Website Name):

    excel
    Copy code
    =LEFT(A1, FIND(“,”, A1) – 1)
    In cell C1 (for URL):

    excel
    Copy code
    =MID(A1, FIND(“,”, A1) + 1, LEN(A1) – FIND(“,”, A1))

      • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Sidebar

Ask A Question

Stats

  • Questions 11k
  • Answers 3k
  • Best Answers 31
  • Users 12k
  • Popular
  • Answers
  • Shinchan

    https://www.devex.com/people/can-i-cancel-and-get-a-refund-with-british-airways-2458295

    • 29 Answers
  • juunu

    https://www.giantbomb.com/forums/general-discussion-30/speakrealperson-how-does-southwest-24-hour-check-i-1926113/

    • 14 Answers
  • nishirajvanshi5

    Where to find the activation code?

    • 9 Answers
  • Care_Promise
    Care_Promise added an answer If you're located in Melbourne, Australia, Care Promise provides full… July 10, 2025 at 1:31 pm
  • vibrantfinance
    vibrantfinance added an answer If you are looking to buy your first home in… July 10, 2025 at 1:21 pm
  • divinelifecare
    divinelifecare added an answer People living in Perth, Australia can have access to essential… July 10, 2025 at 1:12 pm

Related Questions

  • Why Willan Technologies a trusted tech company in Columbus, Ohio?

    • 1 Answer
  • Why should businesses choose Willan Technologies for SEO solutions?

    • 1 Answer
  • How can Matebiz help travel businesses to grow online effectively?

    • 1 Answer
  • What are the benefits of buying car accessories online?

    • 1 Answer
  • Can I backup only selected folders from my IMAP account?

    • 1 Answer

Top Members

getadmin

getadmin

  • 3k Questions
  • 3k Points
Enlightened
Digital

Digital

  • 2k Questions
  • 2k Points
Enlightened
janvi4sure

janvi4sure

  • 666 Questions
  • 819 Points
Enlightened

Trending Categories

Blogs Business Construction Cryptocurrency Digital Marketing Education Electric Vehicle Entertainment Events Fashion Health Law Lifestyles News Others Real Estate SEO Services Software Technology Travel

Explore

  • Home
  • Add group
  • Groups page
  • User Profile
  • Feed
  • Communities
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Polls
  • Tags

Footer

Get Up Genie

Get up Genie helps to share the latest free best question and answer websites across the world. We help to share the trending questions and answers in all industries people.

About Us

  • Meet The Team
  • Home
  • Blog
  • About Us
  • Contact Us

Legal Stuff

  • Terms of Use
  • Terms of Use
  • Privacy Policy
  • Privacy Policy
  • Cookie Policy
  • Cookie Policy

Help

  • Knowledge Base
  • Knowledge Base
  • Support
  • Support

Follow

© 2024 Get Up Genie. All Rights Reserved
With Love by Get Up Genie

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.