cut and paste words & numbers separately

[FrecklePaw]

Hi everyone, I've got some data I'd like to cut and paste into Excel - it's a whole load of #hashtags with popularity counts that someone typed for me in MS Word, but now I want to separate it by hashtag in one column and then the numerical value in another. How can I mass cut and paste the data I have in so it will automatically separate the text from the numbers into a different column.

i.e. what I have in Word is written like this:

#hashtag name 190k
#hashtag name 15k
#hashtag name 1k

etc etc

Is there a way to do this so the hasthtags (words) can go in one column and the numericals in a column next to each other?

Thanks!

[HansV]

Paste the values into Excel.
Select them (or the entire column).
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next>.
Tick the check box for Space. If all is well, you should see the data split in the preview below.
Click Finish.
If it doesn't work, press Ctrl+Z to undo the change.

[FrecklePaw]

Perfect Hans! I thought I'd have to retype - thanks v much :)

[FrecklePaw]

One further query arises now that I've done that - unfortunately we've put in 19k for 19,000 and 2m for 2,000,000 - is there a way to convert these into the proper numerical from the k and m representative letters? :/

[HansV]

Select the number column.
Press Ctrl+H to activate the Replace dialog.
Enter k in the Find what box and 000 in the Replace with box.
Click Replace All.
Do the same with m and 000000