Attendance table Text Value Convert to Number

NBVC · #1 11-07-2018, 12:02 PM

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...

NickFazer · #2 11-08-2018, 01:29 AM

Quote:

Originally Posted by NBVC

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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