Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Help! Separating Words in a sentence in Excel 2003 cells


  • Please log in to reply

#1
eckooo82

eckooo82

    New Member

  • Member
  • Pip
  • 2 posts
I am working on a large excel 2003 spreadsheet and accidentally combined words into a sentence in one column using find and replace tool since I wanted to get rid of beginning spaces! And then I hit save!!! Now all the words are combined and it will take me weeks to manually separate the words (there are over 4000 rows). :whistling: ! The project is due in a few days and am not sure what to do. I have looked for tips on how to undo this dilemma but there doesn't seem to be any on the web. Please help!!!
Thanks!

Example of a combined sentence.
ASAP - AsSoonAsPossible.
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
seeing as the waiting room is a place specifically for posting if you have a thread ALREADY open and haven't gotten help for 3 days...and you don't match these criteria....you've posted this in the wrong spot....i'm gonna move this thread to the right place..

also...you've got two options

#1...do it the manual way and just go put the spaces

#2...if all of the cells are filled with rellatively the same information (i.e. they all start with the word "test") then you could do another replace and put "test" in what to look for and put "test " (notice the space) in the replace field...this would replace all instances of "testthisthing" with "test thisthing" then you would just need to continue on through the rest of the common words in the sheet..not quite the speediest thing but it's a little faster
  • 0

#3
eckooo82

eckooo82

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Thanks for the heads up and also for the prompt reply!! I will try the second option.
  • 0

#4
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
eckooo82

I just noticed that in your example all words are capitalised.
If this is true of your data then you could check the match case option in the Excel find and replace dialogue.

The replace "A" with " A"
"B" with " B"
....
and finally "Z" with " Z"


Hope this helps
dsm
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP