Convert text to numbers in 2003 MS Word

huffman

New member
Pro User
Local time
3:51 AM
Messages
715
I need to be able to convert text to numbers in 2003 Word.
Unfortunately I have what appears two types of information on a line such as:

Walmart 7.40

I just want to convert the 7.40 to a number.

Any help is appreciated.
 

My Computer My Computer

At a glance

Windows 7 ProIntel(R) Pentium(R) Duel CPU E2200 2.20 Ghz4 gb 2.96 UsableOnboard
OS
Windows 7 Pro
CPU
Intel(R) Pentium(R) Duel CPU E2200 2.20 Ghz
Motherboard
GA-G41M-ES2L
Memory
4 gb 2.96 Usable
Graphics Card(s)
Onboard
Sound Card
Onboard
Hard Drives
2 - 1TB WD Sata Drives
If you can find a pattern for the information, such as the number always being the last item in the cell, then you could use "Text to Columns" to separate the number from the text portion. I am assuming that all of the information in question is in one column. If not, then it would be very helpful to rearrange it in that way.

1. Make sure that the column to the right of the column with the data in it is empty. If necessary, add a blank column to the right of the column with the data in it.

2. Highlight the column with the data in it. Click Data / Text to Columns.

3. You now need to decide how to divide up the data. If there is always one space between the word and the number, then you can choose Delimited, then choose Space as your delimiter. If there are always eight characters/spaces to the left of the number, then you can choose Fixed Width. If necessary, do only some of the data at a time, in order to be able to group the data in patterns.

4. Work your way through the Text to Columns menus, until you are back in the spreadsheet. Your numbers should be in a column by themselves. You can then convert to numeric in one of two ways:

a. Highlight the numbers, then choose Currency (or Number) as your data type.
b. Highlight the numbers, then put in the following formula: =value() --> the cell range needs to be in the parentheses.
 

My Computer My Computer

At a glance

Linux Mint 18.2 xfce 64-bit (VMWare host) / W...Haswell4 GB
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell
OS
Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
CPU
Haswell
Memory
4 GB
Monitor(s) Displays
Acer 23"
Screen Resolution
1920 x 1080
Hard Drives
Two hard drives, 1TB each: One for Linux, one for my data.
Keyboard
IBM Model M
Antivirus
Sophos (Linux), Trend Micro (Windows)
Browser
Firefox, Opera
Other Info
I use Samba to share my data drive with the other computers at my house and with my guest session in VMWare Workstation Player.

My Computer My Computer

At a glance

Win 10 x64, Linux Lite, Win 7 x64, BlackArch,...
Computer type
PC/Desktop
Computer Manufacturer/Model Number
HP Desktop & Compaq Laptop
OS
Win 10 x64, Linux Lite, Win 7 x64, BlackArch, & Kali
Hard Drives
Samsung 850 Pro 256Gb,
Hitachi HDD 1Tb,
Crucial MX SSD 250Gb
Segate 3Tb USB 3.0 Ext. Backup HDD
Internet Speed
150Mbps dn, 20Mbps up
Antivirus
Avast Free, Malwarebytes Anti-Exploit & Anti-Ransomware
Browser
Firefox, Chrome, Opera, & VPN
Back
Top