remove space

C

capreecorn

how can i remove space in start of value by using formula ( 222) into (111)

( ) assuming cell.
 
J

Jacob Skaria

Suppose A1 = " 123"

In B1 use the formula '=Trim(A1)' will change that to "123"


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2013 field code Nested IF statement 1
Printer Page & Drawing Page 0
copying_data_using_FillHandle 1
Copy and Pasting with Macros 0
Solved Disk Full error message when exporting PDF 0
transposing layout to table format 6
Only matach two excel spread sheet 2
Changing login email address for office 365 admin (O365 Busines) 0

Top