space

I have a spreadsheet with thousands of lines but I will just show one line because each row is independent. For the life of me I cannot figure out how to format the example in this message space, so I put a public link to a Google Sheet, but I am using EXCEL for the actual spreadsheet not...

So My sheet looks bad as cells text spill over into unused cells. I see if I add a "space" that will stop that from happening. Can anyone suggest a way to be able to search thru the sheet and if the cell is blank auto populate it with a "Space"? Or even better a conditional formatting so it is...

Currently using [bhos123] 's solution but I have to find and replace the commas that appear as I don't need them (commas also appear in column C) ; so my patched together combined macro works but it obviously can be better if I can remove the comma problem. [Kutools Advanced combine rows VBA...

Just wondering, why does the workbook need to recalculate when u resize a column? (my guess is, that sometimes values [such as dates] are displayed as ##### for lack of space, so it needs to recalculate those to show them...) [[[edit: my guess is probably wrong, because i just set my workbook...

I'm using the following formula to return everything in the referenced cell except the text between the first and second space. The word b/w the first and second space has to be taken out. I have several hundred cells that I need to apply this to in different workbooks...

sheet 1 - I have a first name in 1 box and a surname in another. I then combined them using '&' in a formula, with a space, and pasted values so I now have first name space surname - I then tried to lookup that name in Sheet 2, and bring back a value next to it. My issue I get #n/a as the...

I have a huge document with tons of these. And I always decide randomly which I will use on a given day. But I bet one of them takes up less space... thoughts? MC

I have the following various length text string: Hello World 123 abc; Love Excel 365 I would like to substitute the ";" plus one space with a hard space so that I get my results to show in two separate lines like this: Hello World 123 abc Love Excel 365 Can someone assist with the formula...

I am looking for a way to export data in a delimited format to text. To be clear, I have data in cells, and I need to export that to a text document to be uploaded into SAP. I can, easily enough, code a macro convert everything to text format, and add the appropriate number of spaces to the...

I have been given many existing data coded as follows "EXMPL1A 05/25/2018 2,150.00 D" (without quote marks) each datum is this format: a descriptor, space, date in mm/dd/yyyy, space, Amount numeric with 2 places to the right of the decimal, space, alpha-character. I need to convert the example...

Hi all, I'm trying to use this argument (arg): 'T:\SUPERVISOR REPORTS\2018\[May 2018.xlsx]10-D!R7C2 like this: GetValue = ExecuteExcel4Macro(arg) BTW, arg is created like this: arg = "'" & path & "[" & file & "]" & sheet & "!" & Range(ref).Range("A1").Address(, , xlR1C1) (it was found...

Good morning Wondering if it is conceivable to search if a cell contains "PO" "PO1", "PO3" up to possibly "PO8" in a string and return the data on the left which will be separated by a space. Ex. Northwest 654 PO1 ID236 The "PO" is not in the same position in all cells. Thank you

Hi all, I'm hoping someone can help me! I'm working with some data where each cell contains multiple entries (which are unique references). Essentially I want to compare A2 and B2 to show how many entries should still be live. I can get a numerical view of this in C2 by using...

HI Im trying to have the below two formulas combined so that i can remove the first part of text before space and last of a text in same cell after " (". appreciate any help. text in cell A2 <tbody> 200593 Senior Products Systems (United) </tbody> the formula in B2 this cuts out...

Hi I know =countblank() would count empty cells, but how to count empty cells (which look empty but has space char entered)? Thank you so much.

Take three Words separated by spaces. I want the first letter after the space from each word and insert into a cell.

I tried to send a pm to a member here. ut when I submit send I get this wweird message: "You have reached your stored private message quota and cannot send any further messages until space has been created." I'm new here. How can I have "stored" pms if I never sent any?

Im trying hard to find a solution to move a Frame to a defined place in my vba Userform. I actually want to hide/unhide objects which works well but as soon as an object is hidden the space is left BLANK. I want to make sure that there's no blank space on my userform and i would like to replace...

Hello all, I want to add spaces between the characters in the string. The macro should add space between each character.If already space is exist it should ignore and add only where space is required. The string is in last used row of H column. Thank you.

Hello all, i want to remove more than one space between the contents in the string. The string is always in the last used cell of H column. The string contains both single and double spaces. The macro should delete the double space alone and leave the single space as it is. Please heads up...