Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2018, 08:18 AM
NickFazer NickFazer is offline Attendance table Text Value Convert to Number Windows 7 64bit Attendance table Text Value Convert to Number Office 2003
Novice
Attendance table Text Value Convert to Number
 
Join Date: Sep 2018
Posts: 8
NickFazer is on a distinguished road
Default Attendance table Text Value Convert to Number

Hi




I have a table that supervisors enter staff data into each day, currently I have two sheets and would like to amalgamate them to a singe sheet. My issue is that two categories are both numeric entries hourly, but I need to put them into separate categories, my plan was to use the following for Eng Days use E1, E2, E3 etc to represent the number of hours used. Is it possible to extract the 2nd character and treat it as a number in a total column?


Hope this makes sense.

Thanks

Nick
Reply With Quote
  #2  
Old 11-07-2018, 12:02 PM
NBVC's Avatar
NBVC NBVC is offline Attendance table Text Value Convert to Number Windows 10 Attendance table Text Value Convert to Number Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

something like..


=MID(A2,2,10)+0


or if it is always 1 digit, then..


=RIGHT(A2)+0



where A2 contains the original stirng like E2...
Reply With Quote
  #3  
Old 11-08-2018, 01:29 AM
NickFazer NickFazer is offline Attendance table Text Value Convert to Number Windows 7 64bit Attendance table Text Value Convert to Number Office 2003
Novice
Attendance table Text Value Convert to Number
 
Join Date: Sep 2018
Posts: 8
NickFazer is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
something like..


=MID(A2,2,10)+0


or if it is always 1 digit, then..


=RIGHT(A2)+0



where A2 contains the original stirng like E2...
Many Thanks The Formula Guy, works great.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attendance table Text Value Convert to Number Macros to convert text to Table josia Word VBA 3 08-28-2015 09:11 PM
Convert Text To Table: Separate text at (Other)? tinfanide Word VBA 2 01-12-2015 05:26 AM
Attendance table Text Value Convert to Number Cannot Convert Text Cell to number format to be able to sort the data jyfuller Excel 10 06-19-2013 05:31 PM
Convert graphic to text in a table Jennifer Murphy Word 6 01-24-2013 12:56 PM
Convert Number to Text devcon Word 0 07-10-2010 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft