how to remove char in cell with conditional
Dear all,
In cell, I have the text with many Space at many different position.
How to remove them with conditional at [A1]?
Example : ab c ed mjg kjk
If (a1=4, remove the first space, if (a1=5, then remove the 2nd space, ,,, repeat formula to remove all the space)
Thank you,
vumian
Not entirely clear but if we assume:
ab c ed mjg kjk
resides in A2 and you wish to have adjusted string in B2 where adjustment determined by A1 then
B2:
=IF(A1-3>0,SUBSTITUTE(A2," ","",A1-3),"?")
I confess I don't understand the significance of 4 for space 1, 5 for 2 etc...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: how to remove char in cell with conditional
I attached the file for more detail, please help
Thank you
Looks a little like homework...
If it is homework I would suggest first working through the above before submitting it so that you can answer any questions should they arise...
Please Login or Register to view this content.
Thanks alots , it is not a homework, i stuck that issue on my job.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks