Substitute
How I can change in cell B1, value of the A1 cell in a sample like bellow:
from A1 3355789 to B1 35789
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 505 guests online.
New Excel Experts
Current Excel / VBA Jobs |
SubstituteHow I can change in cell B1, value of the A1 cell in a sample like bellow: from A1 3355789 to B1 35789 |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Hi,
Try this formula in B1
=RIGHT(A1,5)
Hope this helps
Helps 100% Mucho Thanks
Helps 100% Mucho Thanks